How to use "NETWORKDAYS" Formula in Excel

This function will calculate the number of working days between two dates. You can simply use the  subtraction method but the  Benefit of this Function is, It will exclude weekends and any holidays.

Syntax:
=NETWORKDAYS(StartDate,EndDate,Holidays)

Example:

Here is the video tutorial of the same for clear understanding.

Back to MS Excel>>