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.
Returns a signed whole number of workdays. Both endpoints are counted when they are workdays.
Jan 15 → Jan 20, 2024 measured four ways. The function you pick decides what 'days between' means.
| Expression | Result | Why |
|---|---|---|
| =NETWORKDAYS(DATE(2024,1,15),DATE(2024,1,20)) | 5 | Business days, both endpoints included |
| =DAYS(DATE(2024,1,20),DATE(2024,1,15)) | 5 | Calendar difference — same number here, different meaning |
| =DAYS(DATE(2024,1,20),DATE(2024,1,15))+1 | 6 | Inclusive calendar count (count every day touched) |
| =NETWORKDAYS(DATE(2024,1,15),DATE(2024,1,20),DATE(2024,1,16)) | 4 | Business days minus one holiday |
| =NETWORKDAYS(DATE(2024,1,13),DATE(2024,1,14)) | 0 | Weekend-only span: zero business days |
| =NETWORKDAYS(DATE(2024,1,15),DATE(2024,1,15)) | 1 | A single workday counts as 1 |
All presets are exact and engine-stable. Edit the grid dates and every gallery row recomputes live.
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.
NETWORKDAYS is universal across Excel versions and Google Sheets; NETWORKDAYS.INTL (custom weekends) requires Excel 2010+.
| Platform | Support | Notes | Gotcha |
|---|
NETWORKDAYS is one piece. The full course walks the toolkit end to end with live, measured examples.