< Go Back

Excel WORKDAY.INTL Function

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

Generic Formula

=WORKDAY.INTL(start_date,workdays,[weekend],[holidays])

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.

Example

Considering the examples below:

Figure 1 – Excel WORKDAY.INTL Function

Explanation

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.

Notes:

WORKDAY.INTL function can return a date in the past if workdays is a negative number.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar