Introduction
The WORKDAY function in Excel helps calculate a date after or before a specified number of working days. It automatically skips Saturdays and Sundays and can also exclude company holidays. This function is useful for calculating project deadlines, delivery dates, payment schedules, and employee-related dates.
What Is the WORKDAY Function in Excel?
The WORKDAY function calculates a future or past working date based on a starting date and the number of working days.
For example, suppose a project starts on Monday, 09-Nov-2026, and the team needs five working days to complete it.
=WORKDAY(A2,5)
Expected Result: 16-Nov-2026
Excel skips Saturday and Sunday while calculating the date.
You can use WORKDAY to:
- Calculate project completion dates.
- Find payment due dates.
- Calculate product delivery dates.
- Plan employee joining dates.
- Calculate deadlines after excluding holidays.
WORKDAY Function Syntax
=WORKDAY(start_date,days,[holidays])
Understanding the Arguments
| Argument | Meaning |
|---|---|
| start_date | The date from which Excel starts counting working days. |
| days | The number of working days to move forward or backward. |
| holidays | Optional dates that should be excluded from the calculation. |
How Does the Days Argument Work?
The days argument tells Excel how many working days to move from the starting date.
| Days Value | Meaning |
|---|---|
| 0 | Returns the starting date |
| 1 | Moves to the next working day |
| 2 | Moves two working days forward |
| 5 | Moves five working days forward |
| -1 | Moves one working day backward |
| -2 | Moves two working days backward |
| -5 | Moves five working days backward |
Important: The starting date itself is not counted when the days argument is positive or negative. Excel begins counting from the next working day or previous working day.
For example, if the starting date is Monday, 09-Nov-2026:
| Formula | Expected Result |
|---|---|
=WORKDAY(A2,0) | 09-Nov-2026 |
=WORKDAY(A2,1) | 10-Nov-2026 |
=WORKDAY(A2,2) | 11-Nov-2026 |
=WORKDAY(A2,5) | 16-Nov-2026 |
=WORKDAY(A2,-1) | 06-Nov-2026 |
=WORKDAY(A2,-2) | 05-Nov-2026 |
How Does WORKDAY Exclude Weekends and Holidays?
By default, WORKDAY considers Monday to Friday as working days.
It automatically skips:
- Saturday
- Sunday
- Dates included in the optional holiday list
Let’s understand this with an example.
Suppose:
- Starting Date: 09-Nov-2026 (Monday)
- Working Days: 5
| Date | Day | Counted? |
|---|---|---|
| 10-Nov-2026 | Tuesday | Yes – Day 1 |
| 11-Nov-2026 | Wednesday | Yes – Day 2 |
| 12-Nov-2026 | Thursday | Yes – Day 3 |
| 13-Nov-2026 | Friday | Yes – Day 4 |
| 14-Nov-2026 | Saturday | No |
| 15-Nov-2026 | Sunday | No |
| 16-Nov-2026 | Monday | Yes – Day 5 |
Expected Result: 16-Nov-2026
Excel skips the weekend and returns the date on which the fifth working day is completed.
Practical Examples of WORKDAY Function in Excel
Question 1: Calculate a Project Completion Date
Problem Statement:
A project manager wants to calculate the completion date of different projects based on their start dates and required working days.
Project Data:
| Project Name | Start Date | Required Working Days |
|---|---|---|
| Website Development | 09-Nov-2026 | 5 |
| Mobile Application | 10-Nov-2026 | 7 |
| Database Setup | 11-Nov-2026 | 10 |
| Software Testing | 12-Nov-2026 | 3 |
Excel Formula:
Enter this formula in D2:
=WORKDAY(B2,C2)
Expected Result:
| Project Name | Start Date | Required Working Days | Completion Date |
|---|---|---|---|
| Website Development | 09-Nov-2026 | 5 | 16-Nov-2026 |
| Mobile Application | 10-Nov-2026 | 7 | 19-Nov-2026 |
| Database Setup | 11-Nov-2026 | 10 | 25-Nov-2026 |
| Software Testing | 12-Nov-2026 | 3 | 17-Nov-2026 |
Explanation:
The formula takes the project start date from B2 and the required working days from C2.
Excel moves forward by the specified number of working days while skipping Saturdays and Sundays.
For Website Development, five working days after 09-Nov-2026 gives 16-Nov-2026.
Concept Covered: Calculating future working dates.
Question 2: Calculate a Payment Due Date
Problem Statement:
An accounts department allows customers five working days to make payments after an invoice date.
Invoice Data:
| Invoice Number | Invoice Date | Payment Period |
|---|---|---|
| INV101 | 09-Nov-2026 | 5 |
| INV102 | 10-Nov-2026 | 7 |
| INV103 | 11-Nov-2026 | 3 |
| INV104 | 12-Nov-2026 | 10 |
Excel Formula:
Enter this formula in D2:
=WORKDAY(B2,C2)
Expected Result:
| Invoice Number | Invoice Date | Payment Period | Payment Due Date |
|---|---|---|---|
| INV101 | 09-Nov-2026 | 5 | 16-Nov-2026 |
| INV102 | 10-Nov-2026 | 7 | 19-Nov-2026 |
| INV103 | 11-Nov-2026 | 3 | 16-Nov-2026 |
| INV104 | 12-Nov-2026 | 10 | 26-Nov-2026 |
Explanation:
The formula calculates the payment due date by moving forward from the invoice date.
The number in the Payment Period column tells Excel how many working days to add.
Weekends are automatically excluded.
Concept Covered: Calculating payment deadlines using working days.
Question 3: Calculate a Product Delivery Date
Problem Statement:
An online store wants to calculate expected delivery dates based on the order date and the number of working days required for delivery.
Order Data:
| Order ID | Order Date | Delivery Working Days |
|---|---|---|
| ORD101 | 09-Nov-2026 | 3 |
| ORD102 | 10-Nov-2026 | 5 |
| ORD103 | 11-Nov-2026 | 7 |
| ORD104 | 13-Nov-2026 | 2 |
Excel Formula:
Enter this formula in D2:
=WORKDAY(B2,C2)
Expected Result:
| Order ID | Order Date | Delivery Working Days | Expected Delivery Date |
|---|---|---|---|
| ORD101 | 09-Nov-2026 | 3 | 12-Nov-2026 |
| ORD102 | 10-Nov-2026 | 5 | 17-Nov-2026 |
| ORD103 | 11-Nov-2026 | 7 | 20-Nov-2026 |
| ORD104 | 13-Nov-2026 | 2 | 17-Nov-2026 |
Explanation:
Excel adds the required number of working days to each order date.
For ORD104, the order is placed on Friday, 13 November. Saturday and Sunday are skipped, so the second working day is Tuesday, 17 November.
Concept Covered: Calculating delivery dates while skipping weekends.
Question 4: Calculate a Future Date After Excluding Holidays
Problem Statement:
A company wants to calculate project completion dates after excluding both weekends and official company holidays.
Project Data:
| Project Name | Start Date | Working Days |
|---|---|---|
| Project A | 09-Nov-2026 | 5 |
| Project B | 10-Nov-2026 | 7 |
| Project C | 11-Nov-2026 | 10 |
Holiday List:
Enter the following holiday dates in F2.
| Holiday Date | Holiday Name |
|---|---|
| 11-Nov-2026 | Company Holiday |
| 13-Nov-2026 | Public Holiday |
| 19-Nov-2026 | Company Holiday |
Excel Formula:
Enter this formula in D2:
=WORKDAY(B2,C2,$F$2:$F$4)
Expected Result:
| Project Name | Start Date | Working Days | Completion Date |
|---|---|---|---|
| Project A | 09-Nov-2026 | 5 | 18-Nov-2026 |
| Project B | 10-Nov-2026 | 7 | 23-Nov-2026 |
| Project C | 11-Nov-2026 | 10 | 27-Nov-2026 |
Explanation:
The formula moves forward by the required number of working days.
Excel skips Saturdays, Sundays, and all holiday dates listed in F2.
For Project A, the normal working-day calculation skips 11 November and 13 November because both are holidays. The fifth working day is 18 November.
The dollar signs keep the holiday range fixed when you copy the formula down.
Concept Covered: Excluding multiple holidays from future working-date calculations.
Question 5: Calculate a Previous Working Date
Problem Statement:
A company wants to calculate the working date five days before different reporting dates.
Reporting Data:
| Report Name | Reporting Date | Days to Move Back |
|---|---|---|
| Report A | 16-Nov-2026 | -5 |
| Report B | 20-Nov-2026 | -3 |
| Report C | 25-Nov-2026 | -7 |
| Report D | 30-Nov-2026 | -2 |
Excel Formula:
Enter this formula in D2:
=WORKDAY(B2,C2)
Expected Result:
| Report Name | Reporting Date | Days to Move Back | Previous Working Date |
|---|---|---|---|
| Report A | 16-Nov-2026 | -5 | 09-Nov-2026 |
| Report B | 20-Nov-2026 | -3 | 17-Nov-2026 |
| Report C | 25-Nov-2026 | -7 | 16-Nov-2026 |
| Report D | 30-Nov-2026 | -2 | 26-Nov-2026 |
Explanation:
A negative value tells Excel to move backward by the specified number of working days.
For Report A, Excel moves five working days backward from Monday, 16 November, and returns Monday, 9 November.
Concept Covered: Calculating past working dates using negative values.
Question 6: Calculate an Employee Joining Date
Problem Statement:
An HR department wants to calculate employee joining dates after a specified number of working days from the offer acceptance date.
Employee Data:
| Employee Name | Offer Acceptance Date | Joining Period |
|---|---|---|
| Rahul | 09-Nov-2026 | 5 |
| Priya | 10-Nov-2026 | 7 |
| Amit | 11-Nov-2026 | 10 |
| Neha | 12-Nov-2026 | 3 |
Excel Formula:
Enter this formula in D2:
=WORKDAY(B2,C2)
Expected Result:
| Employee Name | Offer Acceptance Date | Joining Period | Joining Date |
|---|---|---|---|
| Rahul | 09-Nov-2026 | 5 | 16-Nov-2026 |
| Priya | 10-Nov-2026 | 7 | 19-Nov-2026 |
| Amit | 11-Nov-2026 | 10 | 25-Nov-2026 |
| Neha | 12-Nov-2026 | 3 | 17-Nov-2026 |
Explanation:
The formula uses the offer acceptance date as the starting date and moves forward by the number of working days specified.
For Rahul, five working days after 9 November gives 16 November.
Concept Covered: Calculating future employee joining dates.
Question 7: Calculate a Project Deadline Using a Holiday List
Problem Statement:
A project management team wants to calculate deadlines for different projects. The company has a fixed holiday list that must be excluded from all calculations.
Project Data:
| Project Name | Start Date | Required Working Days |
|---|---|---|
| Project Alpha | 02-Nov-2026 | 5 |
| Project Beta | 09-Nov-2026 | 8 |
| Project Gamma | 16-Nov-2026 | 10 |
| Project Delta | 23-Nov-2026 | 7 |
Company Holiday List:
Enter the dates in F2.
| Holiday Date | Holiday Name |
|---|---|
| 05-Nov-2026 | Company Holiday |
| 11-Nov-2026 | Public Holiday |
| 19-Nov-2026 | Company Holiday |
Excel Formula:
Enter this formula in D2:
=WORKDAY(B2,C2,$F$2:$F$4)
Expected Result:
| Project Name | Start Date | Required Working Days | Project Deadline |
|---|---|---|---|
| Project Alpha | 02-Nov-2026 | 5 | 10-Nov-2026 |
| Project Beta | 09-Nov-2026 | 8 | 20-Nov-2026 |
| Project Gamma | 16-Nov-2026 | 10 | 01-Dec-2026 |
| Project Delta | 23-Nov-2026 | 7 | 02-Dec-2026 |
Explanation:
The formula moves forward by the required working days while excluding weekends and company holidays.
For Project Alpha, Excel skips 5 November because it is a company holiday. The fifth working day is 10 November.
Concept Covered: Building reusable project deadline calculations with a fixed holiday range.
Student Practice Tasks
Try solving these tasks using only the WORKDAY function.
Task 1: Calculate Project Completion Dates
| Project | Start Date | Working Days |
|---|---|---|
| Project X | 01-Dec-2026 | 5 |
| Project Y | 02-Dec-2026 | 7 |
| Project Z | 03-Dec-2026 | 10 |
Calculate the expected completion date of each project.
Task 2: Calculate Delivery Dates After Excluding Holidays
Order Data:
| Order | Order Date | Delivery Working Days |
|---|---|---|
| ORD201 | 01-Dec-2026 | 5 |
| ORD202 | 07-Dec-2026 | 7 |
| ORD203 | 14-Dec-2026 | 10 |
Holiday List:
| Holiday Date | Holiday Name |
|---|---|
| 03-Dec-2026 | Company Holiday |
| 10-Dec-2026 | Public Holiday |
| 18-Dec-2026 | Company Holiday |
Calculate the expected delivery dates after excluding weekends and holidays.
Task 3: Calculate Previous Working Dates
| Report | Reporting Date | Days to Move Back |
|---|---|---|
| Report A | 15-Dec-2026 | -5 |
| Report B | 21-Dec-2026 | -3 |
| Report C | 31-Dec-2026 | -7 |
Calculate the previous working date for each report.
Final Student Challenge: Build a Project Deadline Tracker
Problem Statement:
You are working as a project coordinator. Your manager wants a tracker that automatically calculates project deadlines after excluding weekends and company holidays.
Project Data:
| Project Name | Start Date | Required Working Days |
|---|---|---|
| Website Redesign | 01-Dec-2026 | 10 |
| Mobile App | 07-Dec-2026 | 12 |
| Database Migration | 14-Dec-2026 | 15 |
| Software Testing | 21-Dec-2026 | 8 |
Company Holiday List:
Enter the following dates in F2.
| Holiday Date | Holiday Name |
|---|---|
| 03-Dec-2026 | Company Holiday |
| 10-Dec-2026 | Public Holiday |
| 18-Dec-2026 | Company Holiday |
| 25-Dec-2026 | Christmas Holiday |
Your Tasks:
- Calculate the project deadline using the starting date and required working days.
- Exclude Saturdays and Sundays automatically.
- Exclude all dates in the company holiday list.
- Use an absolute reference for the holiday range.
- Copy the formula for all projects.
Expected Report Structure:
| Project Name | Start Date | Required Working Days | Project Deadline |
|---|---|---|---|
| Website Redesign | 01-Dec-2026 | 10 | Your Result |
| Mobile App | 07-Dec-2026 | 12 | Your Result |
| Database Migration | 14-Dec-2026 | 15 | Your Result |
| Software Testing | 21-Dec-2026 | 8 | Your Result |
Complete the report using the WORKDAY function.
Key Takeaways
- WORKDAY calculates a future or past working date.
- Its syntax is
=WORKDAY(start_date,days,[holidays]). - Positive values move forward by working days.
- Negative values move backward by working days.
- Zero returns the starting date.
- Saturdays and Sundays are excluded automatically.
- You can exclude company holidays using the optional holidays argument.
- Use absolute references to keep the holiday range fixed when copying formulas.
- WORKDAY is useful for project deadlines, payment dates, delivery schedules, and HR planning.
Frequently Asked Questions (FAQs)
1. What is the WORKDAY function in Excel?
WORKDAY calculates a future or past date after adding or subtracting a specified number of working days.
2. What is the syntax of the WORKDAY function?
The syntax is:
=WORKDAY(start_date,days,[holidays])
3. Does WORKDAY exclude Saturdays and Sundays?
Yes. It automatically skips Saturdays and Sundays while calculating the resulting date.
4. Can WORKDAY exclude public holidays?
Yes. You can provide a list of holiday dates in the optional holidays argument.
5. What does a positive number mean in WORKDAY?
A positive number tells Excel to move forward by the specified number of working days.
6. What does a negative number mean in WORKDAY?
A negative number tells Excel to move backward by the specified number of working days.
7. What happens when the days argument is zero?
WORKDAY returns the same starting date without moving forward or backward.
8. Does WORKDAY count the starting date?
No. When the days argument is positive or negative, Excel starts counting from the next or previous working day. If the days argument is zero, it returns the starting date.
9. What is the difference between WORKDAY and NETWORKDAYS?
WORKDAY returns a future or past working date, while NETWORKDAYS counts the number of working days between two dates.
10. Can WORKDAY calculate project deadlines?
Yes. It is useful for calculating project deadlines based on the required working days while excluding weekends and specified holidays.

