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:
Example of NETWORKDAYS.INTL Function in Excel excluding holiday list and weekends
Formula
- 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
Example of NETWORKDAYS.INTL Function in Excel excluding holiday list and Sunday
Formula
- 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).