WORKDAY Function
Returns the date a number of working days before or after a start date.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A date (serial number)
Overview
WORKDAY counts forward (or back) a number of working days, skipping Saturdays, Sundays and any holidays you list. Use it for due dates, delivery dates and SLAs.
The start date itself isn't counted.
Syntax
=WORKDAY(start_date, days, [holidays])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| start_date | Yes | The date to count from. |
| days | Yes | Working days to move: positive for later, negative for earlier. |
| holidays | Optional | A range of dates to skip as well. |
Examples
Example 1 — Delivery dates
Northstar promises delivery in a set number of working days.
C2fx=WORKDAY(A2,B2)
| A | B | C | |
|---|---|---|---|
| 1 | Ordered | Working days | Delivers |
| 2 | 3/13/2026 | 5 | 3/20/2026 |
| 3 | 3/2/2026 | 10 | 3/16/2026 |
| 4 | 3/13/2026 | -1 | 3/12/2026 |
=WORKDAY(A2,B2) Explain
Example 2 — Skipping holidays
List the holidays in a range and lock it with $ signs.
C2fx=WORKDAY(A2,B2,$E$2:$E$3)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Ordered | Working days | Delivers | Holidays | |
| 2 | 3/13/2026 | 5 | 3/24/2026 | 3/16/2026 | |
| 3 | 3/17/2026 |
=WORKDAY(A2,B2,$E$2:$E$3) Explain
Common mistakes
- The result shows as a number. Format the cell as Short Date.
- A different weekend. WORKDAY always treats Saturday and Sunday as the weekend. Use WORKDAY.INTL for other patterns.
Notes
- Related functions: WORKDAY.INTL, NETWORKDAYS, EDATE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.