Date · business days · Nov 2026

NETWORKDAYS.

Count the workdays between two dates — weekends skipped, holidays optional, both endpoints included. Every number on this page was measured on a live formula engine, not copied from a docs table.

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

How NETWORKDAYS works

Returns a signed whole number of workdays. Both endpoints are counted when they are workdays.

=NETWORKDAYS(start_date, end_date, [holidays])
start_dateFirst date of the span (a real date serial).
end_dateLast date of the span. Reversed order gives a negative count.
holidaysOne date or a range of dates to exclude in addition to weekends.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
counting

One span, four different counts

Jan 15 → Jan 20, 2024 measured four ways. The function you pick decides what 'days between' means.

ExpressionResultWhy
=NETWORKDAYS(DATE(2024,1,15),DATE(2024,1,20))5Business days, both endpoints included
=DAYS(DATE(2024,1,20),DATE(2024,1,15))5Calendar difference — same number here, different meaning
=DAYS(DATE(2024,1,20),DATE(2024,1,15))+16Inclusive calendar count (count every day touched)
=NETWORKDAYS(DATE(2024,1,15),DATE(2024,1,20),DATE(2024,1,16))4Business days minus one holiday
=NETWORKDAYS(DATE(2024,1,13),DATE(2024,1,14))0Weekend-only span: zero business days
=NETWORKDAYS(DATE(2024,1,15),DATE(2024,1,15))1A single workday counts as 1
⚠ Both endpoints are included. A Mon→Fri week is 5, not 4 — and a same-day span is 1, not 0. If you want 'nights between', subtract 1.
Use NETWORKDAYS for business-day counts (weekends excluded, holidays optional). Use DAYS for raw calendar distance. They agree on this span by coincidence, not by definition.
// 03 — Try it live

Interactive NETWORKDAYS playground

All presets are exact and engine-stable. Edit the grid dates and every gallery row recomputes live.

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 NETWORKDAYS works

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

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

Master working-day spans

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

  • Inclusive counting vs plain subtraction
  • Weekend-only spans and same-day counts
  • Holiday lists and range references
  • NETWORKDAYS vs NETWORKDAYS.INTL custom weekends
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked