NETWORKDAYS.INTL
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Parameters
- start_date: Required. The start date
- end_date: Required. The end date
- weekend: Optional. A number or string indicating which days are weekends (1=Saturday/Sunday default)
- holidays: Optional. An optional set of dates to exclude
Example
=NETWORKDAYS.INTL("1/1/2024", "1/31/2024", 1)