Parameter List
Syntax
NETWORKDAYS(start_date, end_date,
[holidays]
)start_date
The start date of the period from which to calculate the number of net working days. For example: 2021-09-20.
end_date
The end date of the period from which to calculate the number of net working days. For example: 2022-04-19.
[optional] holidays
A range or array constant containing the dates to consider holidays. For example B1:B5, resulting in ”2022-01-04, 2022-01-05, 2022-01-06, 2022-01-07, 2022-01-10”