About Lesson
WORKDAY and WORKDAY.INTL FunctionÂ
Project Title:
📅 Automatic Task End Date Calculation Using Workday Functions (2025)
Objective:
To calculate task end dates automatically by excluding weekends and holidays using WORKDAY() and WORKDAY.INTL() functions.
🧱 Step 1: Create the Table in Excel
| Task Name | Task Start Date | Duration (Working Days) | Task End Date | Holidays |
|---|---|---|---|---|
| Task-1 | 02-01-2025 | 10 | Â | 26-01-2025 |
| Task-2 | 10-01-2025 | 15 | Â | 15-03-2025 |
| Task-3 | 18-01-2025 | 20 | Â | 14-04-2025 |
| Task-4 | 25-01-2025 | 25 | Â | 01-05-2025 |
| Task-5 | 05-02-2025 | 15 | Â | 15-08-2025 |
🧮 Step 2: Formula for Task End Date
Default (Saturday & Sunday are weekends):
✅ Explanation:
-
B2→ Start Date -
C2→ Duration in Working Days -
E2:E6→ Holiday List Range
The formula automatically calculates the task end date by skipping weekends and holidays.
📅 Step 3: Indian Holiday List (2025)
You can place this list in a separate range, e.g. E2:E10, and reference it in your formula.
| Holiday | Date |
|---|---|
| Republic Day | 26-01-2025 |
| Holi | 15-03-2025 |
| Good Friday | 18-04-2025 |
| Dr. B.R. Ambedkar Jayanti | 14-04-2025 |
| May Day | 01-05-2025 |
| Independence Day | 15-08-2025 |
| Mahatma Gandhi Jayanti | 02-10-2025 |
| Diwali | 21-10-2025 |
| Christmas | 25-12-2025 |