How do I use WORKDAY in Excel?
Use WORKDAY when you want to calculate a due date based on working days. Enter Start date, Number of days, Holiday range in that order, then add optional arguments when needed.
Excel Function
WORKDAY
Returns date shifted by working days.
WORKDAY(start_date, days, [holidays])Arguments
start_date
RequiredEnter a date/reference-related value.
days
RequiredEnter a numeric value.
holidays
OptionalSpecify a reference range. You can drag or click start/end cells.
Practice Preview
Use WORKDAY to return the date 5 workdays after cell B2 (Start Date in column B) using Holiday in column E as holidays. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | ATask ID | BStart Date | CEnd Date | DNotes | EHoliday |
|---|---|---|---|---|---|
| 2 | T001 | 2026/03/01 | 2026/03/05 | Standard task | 2026/03/03 |
| 3 | T002 | 2026/03/03 | 2026/03/10 | Priority task | 2026/03/06 |
| 4 | T003 | 2026/03/05 | 2026/03/12 | Standard task | 2026/03/10 |
| 5 | T004 | 2026/03/08 | 2026/03/14 | Urgent task | 2026/03/12 |
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=WORKDAY(B2, 5, E2:E5)Result
2026/03/11
Practice This Function
WORKDAY FAQ
Where can I practice WORKDAY?
Use the "Start Function Practice" button to jump straight into WORKDAY drills.
What arguments does WORKDAY use?
The main arguments are Start date, Number of days, Holiday range. Start with the required ones, then add optional arguments if needed.