How to Use NETWORKDAYS Function

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

Formula:

=NETWORKDAYS(start_date, end_date, [holidays])

Explanations:

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

Cautions:

  • 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