« Pixilation Part III
Toggling Toolbar Buttons »

NETWORKDAYS Holiday “Errors”

12th October 2004, 01:05 pm by Dick Kusleika

Is NETWORKDAYS giving you the wrong results? It seemed that it was for me. I had ten holidays listed, but it was only subtracting eight! Well, I spent about ten minutes trying to figure it out, then I gave up and googled it. Norman Harker provides the (obvious) answer here:

Why Didn’t I Think of This

The problem was that some of the holidays land on Saturday or Sunday. Dang, there’s some brain cycles I can never get back. Thanks to the anonymous person who presented this problem.

Nwdholiday

Category: Worksheet Functions  |  Comment (RSS)

3 Comments

  1. Boomer:

    The convention for US holidays falling on a weekend is that those on a Saturday are lost, whereas those on a Sunday roll to the following Monday. Therefore for 1978 the New Year’s holiday would be on the 2nd, and Veteran’s Day would be lost.
    This rule is straightforward for US holidays, but can quite involved for other countries.

    13 October 2004, 2:59 am

  2. ross:

    “I had ten holidays listed, but it was only subtracting eight!”

    Yeah OK Dick blame Excel for that little error!!!!!!!!!!!!!!! “Sorry boss, honest mistake like, guv” yeahhhhhhhhhh, -lol ;-)

    13 October 2004, 9:43 am

  3. Franz:

    Guys, How do i change the weekend from Saturday, Sunday to Friday, Saturday in NETWORKDAYS formula?

    19 November 2006, 4:22 am

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment