WORKDAY.INTL function returns a date that is before or after a provided number of workdays. The function allows specifying which days of the week are weekends and excluding specified holidays.
Excel WORKDAY.INTL function
weekday is an optional argument. It indicates which weekdays are weekend days. This value can be number. For example:
weekend can also be a string value which are seven characters “” and “1” only. Seven of these characters represent seven weekdays (Monday, Tuesday, Wednesday Thursday, Friday, Saturday and Sunday). “0” represents the workday, and “1” represent the non-workday. For example:
0001100: weekend days are Thursday and Friday
1100000: weekend days are Thursday and Friday
0000111: weekend days are Friday, Saturday and Sunday.
1111111: is an invalid string
holiday is optional. A set of dates that are as non-workdays.
Considering the examples below:
Figure 1 – Excel WORKDAY.INTL Function
The formula in C7 is
=WORKDAY.INTL(B1,30) returns Jan 11, 2019, is the date after 30 workdays from Dec 1, 2018. weekend is omitted from the function which defaults weekend days are Sat and Sun
The formula in C8 is
=WORKDAY.INTL(B1,30,1,B2:B4) counts the holidays array B2:B4. You cannot omit weekend from the function if you want to indicate holidays argument. Choose 1 to default weekend days are Sat and Sun.
The formula in C9 is
=WORKDAY.INTL(B1,30,"0000111") specifies the weekend days are Fri, Sat, and Sun by the string 0000111.
WORKDAY.INTL function can return a date in the past if workdays is a negative number.