Add N business days to any date — weekends rolled over, holidays skipped, negative offsets supported. The gallery shows ISO dates; the decoder table shows the raw serials underneath.
Returns a date serial. Format the cell as a date, or wrap in TEXT for ISO text.
WORKDAY returns a date serial, not text. These six serials were measured on the engine; the TEXT wrapper turns them into the ISO dates you see in the gallery.
| Expression | Result | Why |
|---|---|---|
| 45303 | 2024-01-12 | Friday — one workday before Jan 15 |
| 45306 | 2024-01-15 | Monday — the start date itself (0 days) |
| 45307 | 2024-01-16 | Tuesday — start + 1 workday |
| 45313 | 2024-01-22 | Monday — start + 5 workdays |
| 45314 | 2024-01-23 | Tuesday — start + 5 with a holiday on the 16th |
| 45320 | 2024-01-29 | Monday — start + 10 workdays |
All presets are exact and engine-stable. Gallery formulas are TEXT-wrapped so the engine itself returns the ISO dates shown.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
WORKDAY is universal across Excel versions and Google Sheets; WORKDAY.INTL (custom weekends) requires Excel 2010+.
| Platform | Support | Notes | Gotcha |
|---|
WORKDAY is one piece. The full course walks the toolkit end to end with live, measured examples.