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.
Formula:
= WORKDAY.INTL(start_date, days, [weekend], [holidays])
Explanations:
- 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.
Cautions:
- 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.
=WORKDAY.INTL(A2,B2,12)
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.
=WORKDAY.INTL(A3,B3,12,C3)
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.
=WORKDAY.INTL(A4,B4,3,C3:C4)