WORKDAY.INTL
Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters
Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Parameters
- start_date: Required. The start date
- days: Required. The number of workdays before or after start_date
- weekend: Optional. A number or string indicating which days are weekends
- holidays: Optional. An optional set of dates to exclude
Example
=WORKDAY.INTL("1/1/2024", 10, 1)