NETWORKDAYS.INTL

Get work days between two dates

Sponsored Link

NETWORKDAYS.INTL

Purpose 

Get work days between two dates

Return value 

A number representing days.

Syntax 

=NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays])

Arguments 

  • start_date - The start date.
  • end_date - The end date.
  • weekend - [optional] Setting for which days of the week should be considered weekends.
  • holidays - [optional] A reference to dates that should be considered non-work days.

Usage notes 

NETWORKDAYS.INTL calculates work days between two dates. Work days exclude weekends (Saturday and Sunday by default) and can optionally exclude holidays. This function is more robust that the NETWORKDAYS function, because it allows you to control which days of the week are considered weekends. The weekend argument is set using the codes listed in the table below.

NETWORKDAYS.INTL can also optionally take into account holidays. For the holidays argument, supply a range that contains holiday dates. These are also treated as non-working days and will not be included in the result.

In the example shown, the following formulas are used:

D4=NETWORKDAYS.INTL(B4,C4)D5=NETWORKDAYS.INTL(B5,C5,17)D6=NETWORKDAYS.INTL(B6,C6,1,B9:B10)
Weekend numberWeekend days
1 (default)Saturday, Sunday
2Sunday, Monday
3Monday, Tuesday
4Tuesday, Wednesday
5Wednesday, Thursday
6Thursday, Friday
7Friday, Saturday
11Sunday only
12Monday only
13Tuesday only
14Wednesday only
15Thursday only
16Friday only
17Saturday only

Notes:

  • If start_date is greater than end_date, the the function returns a negative value.
  • If start_date or end_date are out of range, NETWORKDAYS.INTL returns the #NUM! error.
  • If weekend is invalid, NETWORKDAYS.INTL returns the #VALUE! error.

Sponsored Link

1 votes. 4.5 / 5