Thread: NETWORKDAYS (2000 9.0.4402 SR 1)

1. 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?

2. 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. 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. 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
•