NETWORKDAYS.INTL Function in Excel

NETWORKDAYS.INTL Function in Excel calculates the number of working days between two dates. You can also exclude holidays. It is similar to NETWORKDAYS Function in addition to that NETWORKDAYS.INTL Function allows you to customize which days are considered weekends (non-working days).

Syntax for NETWORKDAYS.INTL Function in Excel

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

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 list of one or more dates that should be considered non-work days

Values for weekend optional Argument:

NETWORKDAYS.INTL Function in Excel formula 1

Example of NETWORKDAYS.INTL Function in Excel excluding holiday list and weekends

Formula

NETWORKDAYS.INTL Function in Excel 1

  • 1 supplied as input to weekend argument which denotes Saturday and Sunday as weekends
  • 23 working days (excluding weekend) are there between Jan-1-2017 is Feb-1-2017
  • 22 working days (excluding weekend) and Excluding Holidays are there between Jan-1-2017 is Dec-1-2017, because of start date less than end date number of working days will have negative value (-22).

So the result will be

Result

NETWORKDAYS.INTL Function in Excel 2

Example of NETWORKDAYS.INTL Function in Excel excluding holiday list and Sunday

Formula

NETWORKDAYS.INTL Function in Excel 3

  • 11 supplied as input to weekend argument which denotes only Sunday as weekend
  • 25 working days by excluding Sunday and Excluding Holidays are there between Jan-1-2017 is Feb-1-2017
  • 27 working days by Excluding Sunday and Excluding Holidays are there between Jan-1-2017 is Dec-1-2017, because of start date less than end date number of working days will have negative value (-27).
Result

NETWORKDAYS.INTL Function in Excel 4

previous-small NETWORKDAYS.INTL Function in Excel                                                                                                                next_small NETWORKDAYS.INTL Function in Excel