NETWORKDAYS

Definition: NETWORKDAYS is a function that calculates the number of working days between two given dates.

Syntax: =NETWORKDAYS(start_date, end_date, [holidays])

Situation: This formula is appropriate when you need to calculate the number of working days between two given dates, excluding weekends and holidays.

Example: If you want to find the number of working days between January 1, 2022, and January 31, 2022, excluding weekends and January 17, which is a holiday, the formula =NETWORKDAYS(“1/1/2022”, “1/31/2022”, {“1/17/2022”}) can be used, which returns 22.