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

178 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!

  24. отдых в геленджике пансионаты с питанием гостиница созвездие тельца воронеж
    анапа отель эллада терренкур кисловодск в симферополе есть море
    кератодермия санаторий шевченко евпатория отель байкал москва

  25. гостиница турист могоча гостиница центр сургут
    лечение болезни шегрена санаторий им кирова кисловодск санаторий красная талка фото
    гостиница армения тула санаторий ульяновская область паратунка гостиницы

  26. геленджик гостевой дом с бассейном пансионат орбита сочи отзывы
    санатории нальчик дом отдыха кострома с бассейном порхов псковская область гостиницы
    гостиницы и отели сочи отель атлантика спб бретон брют анапа

  27. сочи лазаревское как добраться лучшие места отдыха с детьми в россии
    отель славяновский исток железноводск курорт подмосковье дивная хижина селигер
    отдых в крыму частный сектор цены лорд махачкала отель ника смоленск

  28. санаторий архипо осиповка отзывы отдыхающих 2021 отели костромы цены
    империя санаторий евпатория официальный сайт санаторий солнечный сочи фсб пансионаты большого сочи
    отдых в октябре в россии гарден хиллс 3 сочи тверь санатории и дома отдыха

  29. санатории по лечению почек в россии топ 100 российских здравниц
    талион санкт петербург красная поляна санаторий беларусь холидей инн москва сокольники официальный сайт цены
    гостиница в пятигорске бештау отель дюны золотые джемете отель звезда люберцы

  30. AAU Started providing academic services in 1990, Al-Ahliyya Amman University (AAU) was the first private university and pioneer of private education in Jordan. AAU has been accorded institutional and programmatic accreditation. It is a member of the International Association of Universities, Federation of the Universities of the Islamic World, Union of Arab Universities and Association of Arab Private Institutions of Higher Education. AAU always seeks distinction by upgrading learning outcomes through the adoption of methods and strategies that depend on a system of quality control and effective follow-up at all its faculties, departments, centers and administrative units. The overall aim is to become a flagship university not only at the Hashemite Kingdom of Jordan level but also at the Arab World level. In this vein, AAU has adopted Information Technology as an essential ingredient in its activities, especially e-learning, and it has incorporated it in its educational processes in all fields of specialization to become the first such university to do so.
    https://www.ammanu.edu.jo/

  31. бетта военный дом отдыха санаторий волжский самара
    лучшие отели краснодара с бассейном и спа сочи морская звезда пансионат гостиница экипаж адлер
    hilton garden inn москва красносельская livadiysky spa hotel крым ареда 2 3

  32. парк отель солнечный промокод новотель москва сити забронировать
    пансионаты москвы отель арина лоо сочи нива уральская ул 144 краснодар россия
    гостиницы в кузнецке как начать утро правильно пермь прикамье

  33. юджин отель санаторий нарат фмба
    санаторий родина в гаспре лазаревское орешник гостиница татьяна прованс звенигород
    гостиница релакс улан удэ отель марриотт москва цены пансионат риал в сочи

  34. элиста хостел бювет минеральной воды
    демидково бассейн цена купеческий красноярск резиденция на морской санкт петербург
    уролог туапсе гранд афон отель абхазия отзывы хостелы иркутска

  35. санаторий на море октябрь кабардинка
    санаторий остеохондроз позвоночника отели переславль залесского сочи купить тур из москвы с перелетом
    санатории россии для пенсионеров яндекс отели крым отель союз томск

  36. гостевой дом у высоцкой керчь курорты юбк
    объединенный санаторий подмосковье удп рф отзывы о санатории победа в евпатории апшеронск отели и гостиницы
    монарх нижний новгород нева каскад алушта санаторий центросоюза

  37. санаторий анапа г анапа официальный сайт профилакторий екатеринбург
    алтайский замок официальный сайт гостиница в муроме цены отель гамма сириус сочи отзывы
    облучье гостиницы санаторий жемчужина набережные челны фото прометей плюс вв

  38. санатории адлер сочи пансионат южная ночь сочи официальный сайт
    где в россии лечат псориаз оздоровительный комплекс прометей ялта грин парк
    геленджик отели у моря с бассейном отель гранд палас в светлогорске лоо горный

  39. гостиница анатоль адлер отель горки нижний новгород официальный
    отель в кирове недорого железноводск ул калинина 16 черноморья
    открытые зимние бассейны крым золотое руно пятигорск санаторный комплекс саки

  40. I have been surfing online greater than 3 hours today, yet I never discovered any fascinating article like yours. It?¦s lovely value sufficient for me. In my opinion, if all web owners and bloggers made good content material as you did, the internet will likely be much more useful than ever before.

  41. hey there and thanks on your info – I have definitely picked up something new from proper here. I did alternatively experience some technical issues the usage of this web site, since I experienced to reload the website many instances previous to I may just get it to load properly. I were puzzling over in case your web host is OK? No longer that I am complaining, however sluggish loading cases times will often affect your placement in google and can damage your high quality score if advertising and ***********|advertising|advertising|advertising and *********** with Adwords. Anyway I am including this RSS to my e-mail and could look out for a lot extra of your respective exciting content. Make sure you replace this once more soon..

  42. cancun family vacation package all-inclusive
    [url=https://inanitplet1971.qodsblog.com/16362961/tale-about-easy-banana-cream-pie-filling-recipe]5 star cancun beach resort[/url]

  43. all inclusive cancun vacation with air
    [url=п»їhttps://bersnikuten1976.ezblogz.com/46497710/tale-about-easy-banana-cream-pie-recipe-with-cream-cheese]five star all inclusive cancun[/url]

  44. adult only resort in cancun
    [url=https://itrecromark1980.dsiblogger.com/46511271/tale-about-easy-banana-cream-pie-recipe-with-whipped-cream]cancun hotels on the beach all inclusive[/url]

  45. I am just writing to let you know what a fabulous discovery my cousin’s girl went through checking your web page. She picked up plenty of things, with the inclusion of what it is like to have a wonderful helping mood to make a number of people really easily know several extremely tough issues. You truly exceeded her expectations. Thank you for offering these effective, trustworthy, edifying as well as unique guidance on your topic to Julie.

  46. hotels resorts in cancun mexico
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]all inclusive cancun holidays[/url]

  47. all inclusive hotels in cancun mexico
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]gay friendly resorts cancun[/url]

  48. cheap trips to cancun
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]cancun hotels all inclusive adults-only[/url]

  49. cancun dream getaways reviews
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]cancun all inclusive packages with flights[/url]

  50. whoah this blog is wonderful i really like reading your articles. Keep up the great paintings! You realize, a lot of people are hunting round for this info, you could help them greatly.

  51. Pingback: 2meaning
  52. This is available in doses of 5 milligrams (mg), 10 mg, and 20 mg. Daily: A 5-mg tablet with brand pricing starting from $50 per tablet. Generic tadalafil: A 20-mg tablet starting at $2 per tablet and higher doses starting at $25 per tablet.
    [url=https://comprarcialis5mg.org/] venta de cialis en farmacias[/url]

  53. We are a group of volunteers and opening a brand new scheme in our community. Your web site provided us with helpful information to work on. You have performed a formidable process and our whole group will be thankful to you.

  54. Good day! This is kind of off topic but I need some guidance from an established blog. Is it very difficult to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about setting up my own but I’m not sure where to begin. Do you have any points or suggestions? Appreciate it

  55. Great ?V I should certainly pronounce, impressed with your website. I had no trouble navigating through all tabs and related info ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or something, web site theme . a tones way for your client to communicate. Nice task..

Leave a Reply

Your email address will not be published. Required fields are marked *