Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .