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.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Use of Workday.intl function and exporting of case name to merged cell automatically
Solved by B. A. in 27 mins
help me to convert text value into date format using workday.intl
Solved by A. J. in 25 mins
I want to find the date by adding the number of working hour as well as date using formula Workday or Workday.intl
Solved by K. Y. in 22 mins

Leave a Comment

avatar