How Does Excel NETWORKDAYS Function Work?

Excel NETWORKDAYS function calculates the number of workdays between two dates and returns a positive integer that represents the total number of working days between the two specified dates.

It does not count the weekends between the specified dates and by default, the weekend is set to Saturday and Sunday. It can also exclude any date specified as holidays.

Syntax

 = NETWORKDAYS(start_date, end_date,[holidays])

Input Arguments

  • start_date – a date value that represents the start date
  • end_date – a date value that represents the end date
  • [holidays] – This is optional. It is a range of dates, usually a national or public holiday, that are excluded from the calculation. The holidays could be entered as an array of serial numbers that represent the dates or as a reference to a range of cell that contains the dates.

When Excel NETWORKDAYS Function is Used?

When you want to get the number of working days between two specified dates, you use Excel NETWORKDAYS function. The working days excludes weekends and any date identified as holidays.

The NETWORKDAYS function is very useful in situations where you want to calculate the overtime payments or benefits accrued to employees based on number of days worked or during a project, etc.

Additional Notes

  • By default, Saturdays and Sundays are considered as weekends and so are not counted in the NETWORKDAYS function. If you want to use other days for the weekends, and not Saturday or Sunday, then use the NETWORKDAYS.INTL function.
  • A date can be entered either as:
    • A date stored as text
    • entered as text (that is, in double quotes “ ”)
    • date returned from other formulas
  • If the argument is not valid, NETWORKDAYS function returns the #VALUE! error.
  • The NETWORKDAYS function is not an Excel in-built function. It is part of the Analysis Tool Pack (ATP) and so, if you get a #NAME! error, it could mean that you do not have the ATP or it is not loaded properly. In such a case, it is recommended that you reload the ATP.

How to Use Excel NETWORKDAYS Function: Formulas & Examples

Example 1: Calculating the Number of days Between two dates (Includes Holidays)

NETWORKDAYS function can be used to calculate the number of days between two dates even without specifying any holiday. It automatically does not count Saturdays and Sundays.

In the above example, we calculate the total number of workdays for each month between the first day and last day of the months using the formula:

                =NETWORKDAYS(A5, B5)

As shown in the example, it returns the total the number of days in each month, excluding Saturdays and Sundays.

In this case, there is no holiday specified in the formula.

Example 2: Calculate Number of Workdays (Excludes Holidays)

In this situation, you want to calculate the number of workdays in the months, excluding the weekends and holidays specified.

The formula to use is:

             =NETWORKDAYS(A5, B5, $E$5:$E$15)

In this case, the holiday is specified using the cell reference. The dollar sign used in the formula is to lock the cell column and rows so that it can be applied to the other months when you drag to fill the formula in the other months.

Also, note that the NETWORKDAYS function will only exclude holidays that fall on a weekday. If a holiday falls on a weekend, it will be recognized as a weekend and therefore will not be counted twice.

For instance, in the example above, in the month of December, there are two holidays that fall on Saturday and Sunday. The function will not count the days only based on the fact that the days are weekends and not holiday.

Some Other Excel Functions

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

Check out some other functions in Excel:

  • Excel EDATE Function

211 Replies to “Excel NETWORKDAYS Function: With Examples”

  1. Pretty nice post. I just stumbled upon your blog and wished to say that I have truly enjoyed browsing your blog posts. After all I will be subscribing for your rss feed and I hope you write again soon!

  2. I have realized that online degree is getting common because attaining your college degree online has turned into a popular solution for many people. Quite a few people have not had a chance to attend a traditional college or university yet seek the elevated earning potential and career advancement that a Bachelor Degree provides. Still other people might have a college degree in one field but would want to pursue anything they now develop an interest in.

  3. I happen to be writing to let you know of the remarkable discovery my daughter obtained viewing your site. She even learned a wide variety of things, including what it’s like to have an awesome giving style to have other people easily learn about several multifaceted matters. You undoubtedly did more than our expectations. Thanks for distributing such practical, trustworthy, educational as well as easy tips on that topic to Sandra.

  4. I discovered your weblog web site on google and examine a few of your early posts. Continue to maintain up the superb operate. I simply extra up your RSS feed to my MSN News Reader. Seeking ahead to studying more from you afterward!?

  5. I抣l right away grab your rss feed as I can not find your email subscription link or e-newsletter service. Do you have any? Please let me know so that I could subscribe. Thanks.

  6. Have you ever considered about adding a little bit more than just your articles? I mean, what you say is important and all. However think of if you added some great graphics or videos to give your posts more, “pop”! Your content is excellent but with pics and video clips, this site could definitely be one of the best in its niche. Excellent blog!

  7. They don’t need to attend around for a reside agent (in any case, seventy five percent think it
    takes too lengthy to achieve a reside agent). Over 85
    % of companies with quality customer service are outperforming their rivals.
    When agents resolve a difficulty successfully, 70 p.c of the time,
    that customer will return and do enterprise with the corporate
    again. Though home based business homeowners get a good variety of tax
    write-offs, there’s an excellent probability that you will nonetheless must pay one thing to the tax
    man. Use of those unauthorized payment choices may end in a delay of up
    to 7 business days for payment to publish to your FPL account.
    FPL receives no portion of this fee. Essential: Some companies supply to send your cost to FPL
    on your behalf for a payment without being authorized by FPL.
    The payment covers the price of processing the cost for the Pay
    Brokers. This prolonged network of brokers cost a $1.50 charge.
    So as to offer a larger base of Authorized Pay Brokers, there may be an prolonged
    community of agents that may process payments. Average calls per agent: if there
    are extra calls than brokers can handle, it might signal
    that more employees should be hired.

  8. I’ve been exploring for a bit for any high quality articles or weblog posts on this sort of space .Exploring in Yahoo I eventually stumbled upon this web site.Studying this info So i’m satisfied to express that I’ve an incredibly just right uncanny feelingI came upon exactly what I needed. I so much surely will make sure to don?t fail to remember this web site and provides it a look regularly.

  9. I think this is among the most vital information for me.

    And i am glad reading your article. But should remark on some
    general things, The web site style is great, the articles is really great : D.

    Good job, cheers

  10. What i do not understood is in truth how you’re now not really a lot more smartly-favored than you may be right now. You are very intelligent. You know therefore significantly in terms of this matter, made me in my view consider it from so many numerous angles. Its like men and women don’t seem to be involved unless it?¦s one thing to accomplish with Lady gaga! Your personal stuffs nice. All the time maintain it up!

  11. I would like to voice my gratitude for your kind-heartedness supporting women who must have assistance with this important theme. Your personal commitment to passing the solution throughout appeared to be exceptionally interesting and have frequently allowed ladies just like me to achieve their dreams. This valuable instruction implies a lot to me and extremely more to my fellow workers. Regards; from each one of us.

  12. Very nice post. I just stumbled upon your blog and wanted to say that I’ve really enjoyed surfing around your blog posts. In any case I’ll be subscribing to your rss feed and I hope you write again very soon!

  13. Do you have a spam problem on this website; I also am a blogger, and I was curious about your situation; we have created some nice practices and we are looking to trade techniques with other folks, why not shoot me an e-mail if interested.

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

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

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

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

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

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

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

  21. ялта отель с бассейном и питанием alex resort spa hotel гагра
    гостиница престиж егорлыкская клевер клин самолетом поездом
    отели в ялте для отдыха с детьми солнечный парк отель энд спа грязевая аппликация

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

  23. aripiprazole cheap [url=https://aripiprazolelife.online/]where can i get generic aripiprazole without a prescription[/url] how to buy aripiprazole without a prescription

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

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

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

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

  28. санатории пятигорска с детьми жемчужина моря кабардинка фото
    клинический санаторий полтава крым официальный сайт круглая бухта севастополь парк отель солнечный park hotel spa
    турбазы тверской области с бассейном сосновая роща курганская область цены ра на кузнечном 19 санкт петербург

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

  30. Wonderful blog! I found it while searching on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Many thanks

  31. pharmacie de garde aujourd’hui orange [url=https://maps.google.ca/url?q=https://monstergolfshop.com/forum/topic/cual-es-el-costo-de-fabofurox-en-linea-necesito-receta-para-furosemide-comprar/]https://toolbarqueries.google.ca/url?q=https://www.kiva.org/team/donde_puedo_comprar_ryzolt_tramadol_sin_receta[/url] pharmacie defert avignon .
    pharmacie auchan orleans [url=https://toolbarqueries.google.es/url?q=https://www.kiva.org/team/alsoben_misoprostol_se_vende_sin_receta]https://www.youtube.com/redirect?q=https://www.kiva.org/team/donde_puedo_comprar_norfloxacin_noroxin_sin_receta[/url] pharmacie leclerc falaise .
    pharmacie carrefour [url=https://maps.google.fr/url?q=https://www.kiva.org/team/comprar_calutide_bicalutamide_comprimidos_genrico]https://maps.google.fr/url?q=https://monstergolfshop.com/forum/topic/pharmix-generico-precio-ecuador-comprar-furosemide-barato-ecuador/[/url] pharmacie potin beaulieu .

  32. A formidable share, I simply given this onto a colleague who was doing a little bit analysis on this. And he in fact purchased me breakfast because I discovered it for him.. smile. So let me reword that: Thnx for the treat! However yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading more on this topic. If doable, as you turn into experience, would you mind updating your weblog with extra details? It is highly helpful for me. Big thumb up for this weblog submit!

  33. cancun lifestyle resorts
    [url=https://plumhandtechra1989.topbloghub.com/20783163/history-about-easy-banana-pudding-and-cream-cheese-pie-recipe]cancun all inclusive travel packages[/url]

  34. what is the best hotel in cancun
    [url=https://alkefido1971.sharebyblog.com/16420599/story-about-recipe-easy-banana-cream-pie-no-bake]travel packages to cancun all inclusive[/url]

  35. cheap all inclusive cancun vacations packages
    [url=https://spanbandmisgui1976.blogitright.com/16387516/tale-about-easy-banana-caramel-cream-pie-recipe]cheap resorts in cancun[/url]

  36. cancun hotel zone all inclusive adults only
    [url=https://cossanale1977.look4blog.com/54795515/tale-about-easy-banana-cream-pie-recipes]what is the best all inclusive resort in cancun[/url]

  37. cancun all inclusive vacation deals
    [url=https://alwebtovo1988.articlesblogger.com/37896061/history-about-easy-banana-cream-pie-filling-recipe]cancun adult resorts[/url]

  38. best adults only all inclusive resorts cancun mexico
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]what does all inclusive mean cancun[/url]

  39. best all.inclusive resorts cancun
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]luxury hotel cancun all inclusive[/url]

  40. vacation cancun all inclusive
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]package to cancun all inclusive[/url]

  41. best family resort in cancun
    [url=https://sadasndjhg231.bloginder.com/20650288/tale-about-recipe-easy-banana-cream-pie-no-bake]top ten all inclusive resorts in cancun[/url]

  42. Pingback: 1hundred
  43. Hello! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog to rank for
    some targeted keywords but I’m not seeing very good success.

    If you know of any please share. Kudos!

Leave a Reply

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