NETWORKDAYS ^v2.6.131 ​

Calculates the number of working days between two dates, excluding weekends and holidays.

NETWORKDAYS(start_date, end_date, ...holiday_n)

NETWORKDAYS(start_date, end_date, ...holiday_n)

Parameters ​

• start_date - The start date, represented as an Excel date value.
• end_date - The end date, represented as an Excel date value.
• holiday_n - A date value, represented as an Excel date value. If omitted, no holidays are excluded. (optional)

Examples ​

NETWORKDAYS(44197, 44300)

NETWORKDAYS(44197, 44300)

Result: 74

Note: Calculates the number of working days between the start date (2021-01-01) and the end date (2021-04-14), excluding weekends (Saturday and Sunday).

NETWORKDAYS("2022-04-01", "2022-04-30", "2022-04-05", "2022-04-15")

NETWORKDAYS("2022-04-01", "2022-04-30", "2022-04-05", "2022-04-15")

Result: 19

Note: Calculates the number of working days between the start date (2022-04-01) and the end date (2022-04-30), excluding weekends (Saturday and Sunday) and the specified holidays (April 5 and 15, 2022).