Date · scheduling · Nov 2026

WORKDAY.

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.

D1
fx
=WORKDAY(start, days)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How WORKDAY works

Returns a date serial. Format the cell as a date, or wrap in TEXT for ISO text.

=WORKDAY(start_date, days, [holidays])
start_dateThe date to step from (a real date serial). It is not counted.
daysWorkdays to add. Negative values step backward; 0 returns the start.
holidaysOne date or a range of dates to skip in addition to weekends.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
decoder

Serial ↔ date decoder ring

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.

ExpressionResultWhy
453032024-01-12Friday — one workday before Jan 15
453062024-01-15Monday — the start date itself (0 days)
453072024-01-16Tuesday — start + 1 workday
453132024-01-22Monday — start + 5 workdays
453142024-01-23Tuesday — start + 5 with a holiday on the 16th
453202024-01-29Monday — start + 10 workdays
⚠ A bare WORKDAY result like 45313 is correct — it is the date serial for 2024-01-22. Format the cell as a date, or wrap the formula in TEXT with a yyyy-mm-dd code as this gallery does.
WORKDAY never counts the start date. It steps forward (or backward) one workday at a time, rolls over weekends, and skips any holiday you pass. Landing on a weekend is impossible unless the start itself is one and days is 0.
// 03 — Try it live

Interactive WORKDAY playground

All presets are exact and engine-stable. Gallery formulas are TEXT-wrapped so the engine itself returns the ISO dates shown.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where WORKDAY works

WORKDAY is universal across Excel versions and Google Sheets; WORKDAY.INTL (custom weekends) requires Excel 2010+.

PlatformSupportNotesGotcha
✓ Supported full WORKDAY◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master date stepping

WORKDAY is one piece. The full course walks the toolkit end to end with live, measured examples.

  • The start date is never counted
  • Negative days and backward deadlines
  • Weekend starts and the Monday roll
  • Holiday lists and TEXT formatting
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked