WORKDAY Function in Excel Tutorial

Excel Tutorial

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

ArgumentMeaning
start_dateThe date from which Excel starts counting working days.
daysThe number of working days to move forward or backward.
holidaysOptional 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 ValueMeaning
0Returns the starting date
1Moves to the next working day
2Moves two working days forward
5Moves five working days forward
-1Moves one working day backward
-2Moves two working days backward
-5Moves 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:

FormulaExpected 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
DateDayCounted?
10-Nov-2026TuesdayYes – Day 1
11-Nov-2026WednesdayYes – Day 2
12-Nov-2026ThursdayYes – Day 3
13-Nov-2026FridayYes – Day 4
14-Nov-2026SaturdayNo
15-Nov-2026SundayNo
16-Nov-2026MondayYes – 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 NameStart DateRequired Working Days
Website Development09-Nov-20265
Mobile Application10-Nov-20267
Database Setup11-Nov-202610
Software Testing12-Nov-20263

Excel Formula:

Enter this formula in D2:

=WORKDAY(B2,C2)

Expected Result:

Project NameStart DateRequired Working DaysCompletion Date
Website Development09-Nov-2026516-Nov-2026
Mobile Application10-Nov-2026719-Nov-2026
Database Setup11-Nov-20261025-Nov-2026
Software Testing12-Nov-2026317-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 NumberInvoice DatePayment Period
INV10109-Nov-20265
INV10210-Nov-20267
INV10311-Nov-20263
INV10412-Nov-202610

Excel Formula:

Enter this formula in D2:

=WORKDAY(B2,C2)

Expected Result:

Invoice NumberInvoice DatePayment PeriodPayment Due Date
INV10109-Nov-2026516-Nov-2026
INV10210-Nov-2026719-Nov-2026
INV10311-Nov-2026316-Nov-2026
INV10412-Nov-20261026-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 IDOrder DateDelivery Working Days
ORD10109-Nov-20263
ORD10210-Nov-20265
ORD10311-Nov-20267
ORD10413-Nov-20262

Excel Formula:

Enter this formula in D2:

=WORKDAY(B2,C2)

Expected Result:

Order IDOrder DateDelivery Working DaysExpected Delivery Date
ORD10109-Nov-2026312-Nov-2026
ORD10210-Nov-2026517-Nov-2026
ORD10311-Nov-2026720-Nov-2026
ORD10413-Nov-2026217-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 NameStart DateWorking Days
Project A09-Nov-20265
Project B10-Nov-20267
Project C11-Nov-202610

Holiday List:

Enter the following holiday dates in F2.

Holiday DateHoliday Name
11-Nov-2026Company Holiday
13-Nov-2026Public Holiday
19-Nov-2026Company Holiday

Excel Formula:

Enter this formula in D2:

=WORKDAY(B2,C2,$F$2:$F$4)

Expected Result:

Project NameStart DateWorking DaysCompletion Date
Project A09-Nov-2026518-Nov-2026
Project B10-Nov-2026723-Nov-2026
Project C11-Nov-20261027-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 NameReporting DateDays to Move Back
Report A16-Nov-2026-5
Report B20-Nov-2026-3
Report C25-Nov-2026-7
Report D30-Nov-2026-2

Excel Formula:

Enter this formula in D2:

=WORKDAY(B2,C2)

Expected Result:

Report NameReporting DateDays to Move BackPrevious Working Date
Report A16-Nov-2026-509-Nov-2026
Report B20-Nov-2026-317-Nov-2026
Report C25-Nov-2026-716-Nov-2026
Report D30-Nov-2026-226-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 NameOffer Acceptance DateJoining Period
Rahul09-Nov-20265
Priya10-Nov-20267
Amit11-Nov-202610
Neha12-Nov-20263

Excel Formula:

Enter this formula in D2:

=WORKDAY(B2,C2)

Expected Result:

Employee NameOffer Acceptance DateJoining PeriodJoining Date
Rahul09-Nov-2026516-Nov-2026
Priya10-Nov-2026719-Nov-2026
Amit11-Nov-20261025-Nov-2026
Neha12-Nov-2026317-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 NameStart DateRequired Working Days
Project Alpha02-Nov-20265
Project Beta09-Nov-20268
Project Gamma16-Nov-202610
Project Delta23-Nov-20267

Company Holiday List:

Enter the dates in F2.

Holiday DateHoliday Name
05-Nov-2026Company Holiday
11-Nov-2026Public Holiday
19-Nov-2026Company Holiday

Excel Formula:

Enter this formula in D2:

=WORKDAY(B2,C2,$F$2:$F$4)

Expected Result:

Project NameStart DateRequired Working DaysProject Deadline
Project Alpha02-Nov-2026510-Nov-2026
Project Beta09-Nov-2026820-Nov-2026
Project Gamma16-Nov-20261001-Dec-2026
Project Delta23-Nov-2026702-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

ProjectStart DateWorking Days
Project X01-Dec-20265
Project Y02-Dec-20267
Project Z03-Dec-202610

Calculate the expected completion date of each project.

Task 2: Calculate Delivery Dates After Excluding Holidays

Order Data:

OrderOrder DateDelivery Working Days
ORD20101-Dec-20265
ORD20207-Dec-20267
ORD20314-Dec-202610

Holiday List:

Holiday DateHoliday Name
03-Dec-2026Company Holiday
10-Dec-2026Public Holiday
18-Dec-2026Company Holiday

Calculate the expected delivery dates after excluding weekends and holidays.

Task 3: Calculate Previous Working Dates

ReportReporting DateDays to Move Back
Report A15-Dec-2026-5
Report B21-Dec-2026-3
Report C31-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 NameStart DateRequired Working Days
Website Redesign01-Dec-202610
Mobile App07-Dec-202612
Database Migration14-Dec-202615
Software Testing21-Dec-20268

Company Holiday List:

Enter the following dates in F2.

Holiday DateHoliday Name
03-Dec-2026Company Holiday
10-Dec-2026Public Holiday
18-Dec-2026Company Holiday
25-Dec-2026Christmas Holiday

Your Tasks:

  1. Calculate the project deadline using the starting date and required working days.
  2. Exclude Saturdays and Sundays automatically.
  3. Exclude all dates in the company holiday list.
  4. Use an absolute reference for the holiday range.
  5. Copy the formula for all projects.

Expected Report Structure:

Project NameStart DateRequired Working DaysProject Deadline
Website Redesign01-Dec-202610Your Result
Mobile App07-Dec-202612Your Result
Database Migration14-Dec-202615Your Result
Software Testing21-Dec-20268Your 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.