Syntax
WORKDAY(start_date, days, [holidays])
| Parameter | Description |
|---|---|
| start_date | Parameter of the WORKDAY function. |
| days | Parameter of the WORKDAY function. |
| [holidays] | (Optional.) Parameter of the WORKDAY function. |
Examples
10 business days from today
Formula
=WORKDAY(TODAY(), 10)
Returns the date 10 working days from today, skipping weekends. If today is Thursday April 9, 2026, returns April 23, 2026 (two weeks of weekdays).
With holidays
Formula
=WORKDAY("2026-12-22", 5, {"2026-12-25","2026-12-26"})
Returns December 31, 2026 — 5 working days after Dec 22, skipping Christmas Day and Boxing Day in addition to weekends.
Go back 5 business days
Formula
=WORKDAY(TODAY(), -5)
Returns the date 5 working days AGO. Negative days go backward. Useful for calculating lookback periods in business-day terms.
Common Errors
#VALUE!
Occurs when the start_date is not valid, days is non-numeric, or holiday values cannot be interpreted as dates.
#NUM!
Occurs when the resulting date would fall before the date system's minimum date.
Tips
Inverse of NETWORKDAYS
WORKDAY finds a date from a day count. NETWORKDAYS finds a day count from two dates. They are complementary functions for business-day scheduling.
Negative days
Use negative numbers to go backward: =WORKDAY(A1, -10) returns the date 10 business days before A1. Essential for lookback calculations.
For custom weekends
WORKDAY assumes Mon-Fri workweek. For different weekend definitions, use WORKDAY.INTL with a custom weekend parameter.
Try WORKDAY in Viztab
Import your data and use WORKDAY with 370+ other formulas. No signup required.
Open Viztab