WORKDAY
Returns a date that is the indicated number of working days before or after a date
Syntax
WORKDAY(start_date, days, [holidays])
Parameters
- start_date: Required. A date that represents the start date
- days: Required. The number of nonweekend and nonholiday days before or after start_date
- holidays: Optional. An optional list of dates to exclude from the working calendar
Example
=WORKDAY("1/1/2024", 10)