Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
| Parameter | Description |
|---|---|
| start_date | Parameter of the NETWORKDAYS.INTL function. |
| end_date | Parameter of the NETWORKDAYS.INTL function. |
| [weekend] | (Optional.) Parameter of the NETWORKDAYS.INTL function. |
| [holidays] | (Optional.) Parameter of the NETWORKDAYS.INTL function. |
Examples
Friday-Saturday weekend
Formula
=NETWORKDAYS.INTL("2026-04-01", "2026-04-30", 7)
Returns 22 — counts workdays assuming Friday and Saturday are the weekend (weekend type 7), used in many Middle Eastern countries.
Custom weekend string
Formula
=NETWORKDAYS.INTL("2026-04-01", "2026-04-30", "0000011")
Returns 22 — the 7-character string specifies each day Mon-Sun: 0=workday, 1=weekend. "0000011" means Saturday and Sunday are weekends.
Sunday only weekend
Formula
=NETWORKDAYS.INTL("2026-04-01", "2026-04-30", 11)
Returns 26 — with only Sunday as the weekend day (type 11), there are more working days in the month.
Common Errors
#VALUE!
Occurs when the weekend string is not exactly 7 characters of 0s and 1s, when dates are invalid, or when weekend type is not a valid number (1-17).
#NUM!
Occurs when the weekend argument would make all 7 days non-working (string "1111111").
Tips
Weekend types
1=Sat-Sun (default), 2=Sun-Mon, 7=Fri-Sat, 11=Sunday only, 12=Monday only, etc. The string format "0000011" gives full control over any combination.
String format explained
7-character string of 0s and 1s, Monday to Sunday: "1000001" means Monday and Sunday are weekends. Most flexible option for unusual schedules.
All days cannot be weekends
The weekend string cannot be "1111111" — at least one day must be a workday, or the function returns an error.
Try NETWORKDAYS.INTL in Viztab
Import your data and use NETWORKDAYS.INTL with 370+ other formulas. No signup required.
Open Viztab