NETWORKDAYS Function

The NETWORKDAYS function calculates the number of working days between the two given dates.
Note: The function ignores weekends and the holidays.

Formula:


=NETWORKDAYS(Start Date, End Date, Holidays)
Whereas holidays can be created separately and can be given in a range of cells.

Video Tutorial:


Let us find the number of working days between the given dates, using NETWORKDAYS function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question