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

28 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.

Leave a Reply

Your email address will not be published.