NETWORKDAYS
Returns the number of whole working days between two dates, excluding weekends and optionally specified holidays
Syntax
NETWORKDAYS(start_date, end_date, [holidays])
Parameters
- start_date: Required. A date that represents the start date
- end_date: Required. A date that represents the end date
- holidays: Optional. An optional range of one or more dates to exclude from the working calendar
Example
=NETWORKDAYS("1/1/2024", "1/31/2024", A1:A3)