WORKDAY function
WORKDAY returns the date a given number of working days from a start date, skipping Saturdays, Sundays and any holidays you list. It is good for delivery dates and deadlines.
Example
Read it as a sentence: find the workday 1 day after January 16, 2026, skipping weekends and the holidays listed in H1:H3, which gives 46042.
Excel shows 46042
H
1
2026-01-01
2
2026-01-19
3
2026-02-16
Data
Syntax
WORKDAY(start_date, days, [holidays])
Arguments in [square brackets] are optional.
-
start_date(required) - Starting date.
-
days(required) - Working days to move; positive is forward, negative is back.
-
holidays(optional) - Optional list of dates to skip.
Returns: The date a given number of working days from the start.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=WORKDAY(DATE(2026,1,9),1) | 46034 | Friday + 1 |
=WORKDAY(DATE(2026,1,9),-1) | 46030 | Backwards |
=WORKDAY(DATE(2026,1,10),0) | 46032 | Saturday + 0 |
=WORKDAY(DATE(2026,1,9),1.9) | 46034 | Fractional days |
=WORKDAY(DATE(2026,1,9),{1,2,3}) | 46034 | Array days |
=WORKDAY(DATE(2026,1,16),1,Data!H1:H3) | 46042 | Skips MLK holiday |
=WORKDAY("x",1) | #VALUE! | Bad date |
=WORKDAY(DATE(2026,1,9),"x") | #VALUE! | Bad days |
The Data sheet these formulas read
A cell that starts with = holds that formula.
H
1
2026-01-01
2
2026-01-19
3
2026-02-16
Data
Watch out for
- The start date itself is not counted.
- Returns a serial number; format as a date.
- Holidays must be real dates.
Where it works
- Excel
- WORKDAY is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .