Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

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:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

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

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc