Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    NC
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NETWORKDAYS (2000 9.0.4402 SR 1)

    Anyone else having a problem with NETWORKDAYS? I get -2 as a result beteween 04/03/02 and 04/02/02 Date serial #'s 37349 and 37348 respectively?
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: NETWORKDAYS (2000 9.0.4402 SR 1)

    It is actually working as intended.

    1. It is minus because the you have the later day as the first argument.

    2. It showing 2 because both days are included, Tue the 2nd and Wed 3rd, 2 workdays normally.

    Andrew C

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Location
    NC
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: NETWORKDAYS (2000 9.0.4402 SR 1)

    So, taking this a step or two further, the new version of my attached worksheet goes from positive one to minus 2 in one day? Doesn't seem logical. Whoops...I just realized the obvious. This is not meant to be date addition and subtraction, it's counting the number of working days within the range of dates you give it. If the first date happens to be greater than the second, you get a negative number. In fact, the only way to get zero is to give it two or more contiguous non-working days. I get it now. Thanks for the clarification!

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: NETWORKDAYS (2000 9.0.4402 SR 1)

    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>
    It is possible to obtain zero days as result... The function networkdays has 3 parameters: Initial date, final date and holidays.
    It must have more days between initial date and final date (2 days for example).
    Finally, to include every day in the list of holidays between the initial and final date
    <img src=/S/flatcat.gif border=0 alt=flatcat width=61 height=21>
    A1= 2/Mar/2002
    B1= 3/Mar/2002
    C1:C2= {2/Mar/2002, 3/Mar/2002}
    D1= = NETWORKDAYS (A1,B1,C1:C2)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •