WORKDAY ^v2.6.131 ​

Returns a date that is a specified number of working days (excluding weekends and holidays) away from a given start date.

WORKDAY(start_date, days, ...holiday_n)

WORKDAY(start_date, days, ...holiday_n)

Parameters ​

• start_date - The start date, represented as an Excel date value.
• days - The number of working days to add or subtract from the start date.
• holiday_n - A date value, represented as an Excel date value. If omitted, no holidays are excluded. (optional)

Examples ​

WORKDAY(44197, 10)

WORKDAY(44197, 10)

Result: 44211

Note: Returns the date that is 10 working days (excluding weekends) away from January 1, 2021.

WORKDAY("2022-04-01", -5, "2022-03-25")

WORKDAY("2022-04-01", -5, "2022-03-25")

Result: 44644

Note: Returns the date that is 5 working days (excluding weekends and the specified holidays) before April 1, 2022 (excluding March 25th as a holiday).