How to Use NETWORKDAYS Function

The NETWORKDAYS function returns the number of whole working days between two dates.


=NETWORKDAYS(start_date, end_date, [holidays])


  • Start date is required, the first date.
  • End date is required, the second date.
  • Holidays is optional, the holidays between the two dates.


  • NETWORKDAYS function returns the #VALUE! error value when any argument is not a valid date.
  • Excel stores dates as sequential serial numbers. By default, January 1, 1900 is serial number 1.

Download: NETWORKDAYS Function

Leave a Reply