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.
