WORKDAY.INTL Function Explained
The WORKDAY.INTL Function in Microsoft Excel is used to calculate the date after a specified number of workdays have passed, taking into account weekends and holidays. It takes three arguments: a start date, the number of workdays, and a parameter that specifies which days are considered weekends and holidays. It returns a date value.
WORKDAY.INTL Function Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])
- start_date: The start date from which you want to calculate the end date.
- days: The number of working days you want to add to the start date.
- weekend: (Optional) A number or string that specifies which days are considered weekends. The default value is 11, which represents Saturday and Sunday.
- holidays: (Optional) An array of dates that should not be included when counting working days.