NETWORKDAYS Function
Counts the working days between two dates.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A whole number of days
Overview
NETWORKDAYS counts Monday-to-Friday days between two dates, leaving out any holidays you list. Unlike WORKDAY, both the start and end dates count.
Use it for project durations, days to close a ticket or billable days in a month.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| start_date | Yes | The first date (counted if it's a working day). |
| end_date | Yes | The last date (counted if it's a working day). |
| holidays | Optional | A range of dates to leave out. |
Examples
Example 1 — Working days per period
Count the working days in each project window.
C2fx=NETWORKDAYS(A2,B2)
| A | B | C | |
|---|---|---|---|
| 1 | Start | End | Working days |
| 2 | 3/2/2026 | 3/13/2026 | 10 |
| 3 | 3/1/2026 | 3/31/2026 | 22 |
| 4 | 4/1/2026 | 4/30/2026 | 22 |
=NETWORKDAYS(A2,B2) Explain
Example 2 — Leaving out holidays
Two holidays fall in this March project.
C2fx=NETWORKDAYS(A2,B2,$E$2:$E$3)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Start | End | Working days | Holidays | |
| 2 | 3/2/2026 | 3/31/2026 | 20 | 3/16/2026 | |
| 3 | 3/17/2026 |
=NETWORKDAYS(A2,B2,$E$2:$E$3) Explain
Common mistakes
- One more day than expected. NETWORKDAYS includes both ends. Subtract 1 if the start day shouldn't count.
Notes
- Related functions: NETWORKDAYS.INTL, WORKDAY, DAYS.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.