What is Excel WORKDAY.INTL Function?

Excel WORKDAY.INTL function is a function under Excel Date and Time functions. It was introduced in Excel 2010, and is available in other subsequent versions.

Similar to the Excel WORKDAY function, WORKDAY.INTL function provides a future or past working date based on the number of working days, after excluding weekends and holidays specified.

It is however different from WORKDAY function because it allows us to specify any day, other than Saturday and Sunday as weekends.

How Excel WORKDAY.INTL Works?

With Excel WORKDAY.INTL function, it returns a future or past date after a specified number of working days (excluding weekends and holidays) has been added or deducted from the given start date.

This function takes any day of the week apart from Saturday or Sunday as weekends, as it allows the user to specify any day to be used as weekends.

Syntax

The syntax for WORKDAY.INTL function is:

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

And takes the following Input Arguments:

  • Start_date – This is the initial date to start counting the workdays from.
  • Days – This is the number of wok days to be added to the start_date.
  • Weekend – This is optional. It indicates which days of the week to choose as weekends that will not be counted as working days. Weekend can be entered as a number value or string that specifies what days are weekends.

The number value for weekend days is:

The string values for [Weekend] argument takes a series of seven 0’s and 1’s that represents the seven days of the week. It starts from Monday and ends on Sunday.

Each 0 represents a work day, while each 1 represents a non-working day. See as explained in the additional notes below.

  • [holidays] – This is also optional. It specifies an array of dates listed that are non-working days. The list can be specified as a range of cells containing the dates (A1:A7) or an array of serial numbers that represents the dates (44696, 44880, 44150)

When Excel WORKDAY.INTL Function is Used

The Excel WORKDAY.INTL function is used when making calculations that has to do with the number of workdays employees worked, or the expected delivery time of an order or a project, or to know the dates when invoices are due.

And because you can use any day as weekends, it can be used in different countries that have different days as weekends.

Additional Notes

  • A Date start_date and [holiday] arguments can be entered either as:
    • reference to cells that contain the dates
    • a date result from other function
    • date stored as text
    • the date entered as text (i.e in double quotes)
  • If Excel dates are entered as text, it may be misinterpreted, since Excel interprets date depending on the date system on your computer.
  • A weekend could be any two consecutive days or any single day of the week.
  • Any single day or two consecutive days could be specified as weekend. If you do not specify any day for weekend, Excel will automatically take Saturday and Sunday as weekend. When you enter the weekend argument, Excel displays a drop-down menu for you to select the relevant option.
  • For part-time jobs or jobs that have non-consecutive working days, you will enter the following format in the [Weekend] section of the formula:
    • If you work only Mondays, Wednesday and Fridays, type in “0101011” (Working days are represented by 0, and non-working days represented by 1).
    • In this format, the first number represents Monday and the last number represents Sunday.
    • When using these format, the numbers should be in double quotes.
    • Using the same logic, “1011011” indicates only 2 working days as Tuesday and Friday, and the other 5 days are non-working days.
    • Using the string “1111111” is not valid.

How to Use Excel WORKDAY.INTL Function: Formulas & Examples

To understand how to use Excel WORKDAY.INTL function, let us take a look at some examples.

In the worksheet above, we have used WORKDAY.INTL function in three ways.

Example 1

Suppose you want to get a future or past working date after adding or deducting a given number of days to a particular start_date, you may not specify the weekend if your weekend is Saturday and Sunday as it is shown in column C below.

You can use the formula:

             =WORKDAY.INTL(A7,B7)

Where A7 is the start_date, and B7 is the days argument.

This is because, by default, WORKDAY.INTL function counts only workdays. It does not count weekends which is automatically set to Saturdays and Sundays.

So even if you do not specify any weekend argument, Saturdays and Sundays are taken as weekends and excluded from the workdays.

Also, note that using this formula, the holidays are counted in the workdays because it was not specified in the holiday argument.

Example 2

If you have a situation whereby your weekends are only Sundays or any other day of the week, in this case you use the formula below and as shown in column D of the worksheet.

           =WORKDAY.INTL(A7,B7,11,$G$7:$G$17)

Here, the start_date, days, weekends and holiday arguments are all specified. WORKDAY.INTL excludes only Sundays which is the number code 11 specified for weekends, as well as the cell range of G7:G17 containing the holiday dates.

The weekend argument can take any number code that corresponds with your weekend days displayed by Excel and as shown in the table under the Syntax section.

Example 3

In a situation whereby you run part-time shifts for your business and employees work only on specific days of the week, Excel WORKDAY.INTL allows you to specify the weekend argument using string values that consists of a series of seven 0’s and 1’s that represent each day of the week starting from Monday.  (See additional notes section above).

The formula used here is:

              =WORKDAY.INTL(A7,B7, “0000111”,$G$7:$G$17)

The format here indicates that WORKDAY.INTL will count Mondays, Tuesdays, Wednesdays and Thursdays as workdays, while Friday, Saturday and Sundays as weekends and therefore excluded from the workdays.

The 0’s signify workdays, while 1’s signify weekends.

Note that when using the format, the numbers must be in double quotes.

Common Errors in Excel WORKDAY.INTL Function

The following errors may occur in Excel WORKDAY.INTL function due to the following reasons:

  • #NUM! – This error occurs if the start_date and days arguments specified are invalid dates; or the specified [Weekend] argument is an invalid numeric value.
  • #VALUE! – This occurs if the specified start_date or the array of values specified in [holidays] are invalid dates; or the text string specified for [weekend] argument is invalid; or the value specified for days argument is non-numeric.

Other Related Excel Functions

Thank you for reading Excel WORKDAY.INTL function. You can master Excel by learning other Excel functions.

To learn more, check out these other functions in Excel:

  • EDATE Function

64 Replies to “Excel WORKDAY.INTL Function: With Examples”

  1. Magnificent beat ! I would like to apprentice even as you amend your website, how can i subscribe for a blog web site? The account aided me a acceptable deal. I were a little bit acquainted of this your broadcast offered bright transparent concept

  2. I am not sure where you’re getting your info, but good topic. I needs to spend some time learning much more or understanding more. Thanks for great info I was looking for this info for my mission.

  3. Simply wish to say your article is as amazing. The clearness to your put up is just nice and i could suppose you are an expert in this subject.
    Fine along with your permission allow me to
    clutch your RSS feed to stay updated with drawing
    close post. Thank you one million and please continue the
    gratifying work.

  4. Thanks for one’s marvelous posting! I really enjoyed reading it, you could be a great author.I will be sure to bookmark your blog and definitely will come back in the future.I want to encourage that you continue your great work, have a nice weekend!

  5. Heya i’m for the primary time here. I came across this board and
    I in finding It really useful & it helped me out a lot.
    I’m hoping to present something back and aid others like you aided me.

  6. I think that is one of the so much important information for me.
    And i am glad reading your article. But should commentary on some common issues,
    The web site taste is great, the articles is actually great :
    D. Good task, cheers

  7. It is perfect time to make some plans for the future and it’s time to be happy.
    I’ve read this post and if I could I wish to suggest you some interesting
    things or advice. Maybe you could write next articles referring to
    this article. I wish to read more things about it!

  8. Hello there, I discovered your website by way of Google at the same time as looking for a comparable topic, your site got here up, it seems to be great.
    I’ve bookmarked it in my google bookmarks.
    Hi there, just became aware of your blog through Google,
    and located that it is really informative. I am gonna be careful for brussels.
    I’ll appreciate should you proceed this in future. A lot of other folks will probably be benefited out of your
    writing. Cheers!

  9. Hey! I know this is kinda off topic nevertheless I’d figured I’d ask.
    Would you be interested in trading links or maybe guest authoring a blog post or vice-versa?
    My site addresses a lot of the same topics as yours and I believe we could greatly benefit from each other.
    If you are interested feel free to shoot me an e-mail.
    I look forward to hearing from you! Superb blog by the way!

  10. Have you ever thought about including a little bit more than just your
    articles? I mean, what you say is important and everything.
    But think of if you added some great images or video clips
    to give your posts more, “pop”! Your content is excellent but
    with pics and video clips, this site could certainly be one of the very best
    in its field. Good blog!

  11. When I initially commented I clicked the “Notify me when new comments are added” checkbox and now
    each time a comment is added I get four e-mails with the
    same comment. Is there any way you can remove people
    from that service? Thank you!

  12. Hello there, I discovered your blog by the use of
    Google while searching for a comparable topic, your web site got here up, it appears
    good. I have bookmarked it in my google bookmarks.
    Hi there, simply was aware of your blog via Google, and
    found that it’s truly informative. I am gonna watch out for brussels.

    I’ll be grateful when you continue this in future. A lot of folks can be benefited out of your writing.
    Cheers!

  13. F*ckin’ tremendous things here. I’m very satisfied to see your article. Thanks a lot and i’m having a look ahead to touch you. Will you please drop me a e-mail?

  14. Usually I do not learn post on blogs, but I wish to say that this write-up very
    compelled me to check out and do it! Your writing taste
    has been surprised me. Thank you, quite nice post.

  15. Admiring the time and effort you put into your website and in depth information you present. It’s good to come across a blog every once in a while that isn’t the same unwanted rehashed information. Great read! I’ve saved your site and I’m adding your RSS feeds to my Google account.

  16. Pingback: 1pendulum
  17. I just couldn’t leave your website prior to suggesting that I really enjoyed the usual info an individual provide to your guests? Is gonna be back continuously to check up on new posts

  18. Oh my goodness! Amazing article dude! Thanks, However I am experiencing difficulties with your RSS.

    I don’t know the reason why I cannot join it. Is there anybody having identical RSS issues?
    Anyone that knows the answer will you kindly respond? Thanx!!

    Here is my page 2022

  19. You made some decent points there. I checked on the web for additional information about the issue
    and found most individuals will go along with your views on this site.

  20. Undeniably consider that which you stated. Your favourite justification appeared to be
    on the web the simplest thing to have in mind of.
    I say to you, I definitely get irked whilst other folks consider worries that they just do
    not realize about. You controlled to hit the nail upon the highest and outlined out the
    entire thing with no need side effect , folks can take a signal.

    Will likely be back to get more. Thank you

  21. Hi, I think your website might be having browser compatibility issues.
    When I look at your blog in Opera, it looks fine but when opening in Internet Explorer,
    it has some overlapping. I just wanted to give you a quick heads
    up! Other then that, great blog!

  22. My spouse and i have been quite fortunate when Ervin could deal with his investigation because of the ideas he acquired from your very own web pages. It is now and again perplexing to just choose to be handing out information which most people might have been selling. And now we recognize we need the writer to be grateful to for this. Those illustrations you have made, the simple blog menu, the relationships you will make it possible to instill – it’s mostly fantastic, and it is helping our son and our family recognize that the matter is enjoyable, which is exceedingly pressing. Thanks for all!

  23. I absolutely love your site.. Pleasant colors
    & theme. Did you build this website yourself? Please reply back as I’m
    looking to create my very own website and would like to know where you got this from
    or just what the theme is named. Cheers!

Leave a Reply

Your email address will not be published.