SNETWORKDAYS ^v2.6.131 ​

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

SNETWORKDAYS(start_date, end_date, holidays_comma_delimited)

SNETWORKDAYS(start_date, end_date, holidays_comma_delimited)

Parameters ​

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

Examples ​

SNETWORKDAYS(44197, 44300)

SNETWORKDAYS(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).

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

SNETWORKDAYS("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).