The WORKDAY.INTL function is to return a number that represents a date before or after a number of working days with custom weekend parameters.
= WORKDAY.INTL(start_date, days, [weekend], [holidays])
- Start_date is required, the start date.
- Days is required. The number of nonweekend and nonholiday days before or after start_date: a positive value for a future date; a negative value for a past date.
- [Holidays] is optional, the list of one or more holiday dates to exclude from the working calendar.
- [Weekend] is optional, a weekend number or string that specifies when weekends occur.
- By default, Microsoft Excel uses January 1, 1900 as serial number 1.
- WORKDAY.INTL returns the #NUM! error when holiday is out of range for the current date base value.
Example 1: After 50 working days, January 18, 2016 will be March 16, 2016, if only Monday as weekend.
Example 2: After 50 working days, January 18, 2016 will be March 17, 2016, if only Monday as weekend, and not to count the holidays.
Example 3: After 50 working days, January 18, 2016 will be March 17, 2016, if Monday and Tuesday as weekends, and not to count the holidays.