NETWORKDAYS Function in Excel calculates the number of working days between two dates. NETWORKDAYS Function automatically excludes weekends (Saturday and Sunday) and it can also exclude list of holidays that is provided as an input
Syntax for NETWORKDAYS Function in Excel
NETWORKDAYS (start_date, end_date, [holidays])
start_date – The start date.
end_date – The end date.
holidays – [optional] A list of one or more dates that should be considered non-work days
Example of NETWORKDAYS Function in Excel
Formula
- 23 working days (excluding weekend) are there between Jan-1-2017 is Feb-1-2017
- 22 working days (excluding weekend) 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 Function in Excel with holiday list
Formula
- 21 working days (excluding weekend) and Excluding Holidays 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