Functions
NETWORKDAYS
Number of working days between two dates
Try it
When to use it
When should I use NETWORKDAYS instead of WORKDAY?
Use NETWORKDAYS to count the business days between two dates; use WORKDAY to find a date a set number of business days away.
Use cases
Measure working days in a project window
Count working days excluding a holiday
Used in
operations · hr
Syntax
NETWORKDAYS(start,end,[holidays])Examples
=NETWORKDAYS(DATE(1969,7,16),DATE(1969,7,24)) // => 7
=NETWORKDAYS(40909,40924) // => 11
=NETWORKDAYS(40900,40950,{40909,40924}) // => 35