Syntax
NETWORKDAYS(start_date, end_date, [holidays])
| Parameter | Description |
|---|---|
| start_date | Parameter of the NETWORKDAYS function. |
| end_date | Parameter of the NETWORKDAYS function. |
| [holidays] | (Optional.) Parameter of the NETWORKDAYS function. |
Examples
Workdays in a period
Formula
=NETWORKDAYS("2026-04-01", "2026-04-30")
Returns 22 — the number of weekdays in April 2026. Both start and end dates are included if they are weekdays.
With holidays excluded
Formula
=NETWORKDAYS("2026-12-01", "2026-12-31", {"2026-12-25","2026-12-26"})
Returns 21 — 23 weekdays in December 2026, minus 2 holidays (Christmas Day and Boxing Day).
Days until deadline
Formula
=NETWORKDAYS(TODAY(), B2) - 1
Returns the number of working days remaining until the deadline in B2. Subtracting 1 excludes today for a "days remaining" count.
Common Errors
#VALUE!
Occurs when start_date or end_date is not a valid date, or when the holidays range contains non-date values.
Tips
Both dates are inclusive
NETWORKDAYS counts the start date AND end date as working days (if they fall on weekdays). Subtract 1 if you need an exclusive count.
Holiday list
The third argument can be a range (like H1:H20) containing holiday dates, or an array constant. Maintain a holiday table in your workbook for reuse.
For custom weekends, use INTL version
NETWORKDAYS assumes Mon-Fri workweek. If your weekends are different (e.g., Fri-Sat in Middle East), use NETWORKDAYS.INTL with a custom weekend parameter.
Try NETWORKDAYS in Viztab
Import your data and use NETWORKDAYS with 370+ other formulas. No signup required.
Open Viztab