Date & Time
Modern
NETWORKDAYS
Counts the working days between two dates, excluding weekends and optional holidays.
Available in All versions (Excel 2007+)
Syntax
NETWORKDAYS(start_date, end_date, [holidays])What it returns
The number of working days, as a number.
Arguments
| Argument | Required | Description |
|---|---|---|
start_date |
Yes | The first date. |
end_date |
Yes | The last date. |
holidays |
No | A range of dates to also exclude. |
Example
| A | |
|---|---|
| 1 | Date |
| 2 | 2026-06-01 |
| 3 | 2026-06-30 |
Count
22
NETWORKDAYS counts only the working days, Monday to Friday, between two dates (22).
=NETWORKDAYS(A2, B2)Important to know
Excludes Saturdays and Sundays by default.
Both endpoints are counted if working days.
Use NETWORKDAYS.INTL for custom weekends.