NETWORKDAYS.INTL function
NETWORKDAYS.INTL counts the working days between two dates using weekend days you define yourself. It suits regions or shift patterns that differ from the usual Saturday and Sunday.
Example
Read it as a sentence: count the workdays from January 1, 2024 through January 7, 2024, treating only Sunday as the weekend using weekend code 11, which gives 6.
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Arguments in [square brackets] are optional.
-
start_date(required) - First date.
-
end_date(required) - Last date.
-
weekend(optional) - Number code (1 Sat-Sun default, 2 Sun-Mon, 11 Sunday only, and so on) or a 7-character string of 0s and 1s starting Monday, where 1 is a day off.
-
holidays(optional) - Optional list of dates to exclude.
Returns: The number of working days using your own weekend definition.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=NETWORKDAYS.INTL(DATE(2026,1,1),DATE(2026,1,31)) | 22 | Default weekend |
=NETWORKDAYS.INTL(DATE(2026,1,1),DATE(2026,1,31),11) | 27 | Sunday only |
=NETWORKDAYS.INTL(DATE(2026,1,1),DATE(2026,1,31),7) | 21 | Friday-Saturday |
=NETWORKDAYS.INTL(DATE(2026,1,1),DATE(2026,1,31),"0000011") | 22 | String weekend |
=NETWORKDAYS.INTL(DATE(2026,1,1),DATE(2026,1,31),"1111111") | 0 | Every day weekend |
=NETWORKDAYS.INTL(DATE(2026,1,31),DATE(2026,1,1),1) | -22 | Reversed |
=NETWORKDAYS.INTL(DATE(2026,1,1),DATE(2026,1,31),"000001") | #VALUE! | 6-char string |
=NETWORKDAYS.INTL(DATE(2026,1,1),DATE(2026,1,31),99) | #NUM! | Bad weekend code |
Watch out for
- The string form starts on Monday: "0000011" means Saturday and Sunday off.
- Code 11 means Sunday only, not Saturday and Sunday.
- Both end dates are counted.
Where it works
- Excel
- NETWORKDAYS.INTL arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .