Number of working days between 2 dates
 

So I've seen similar posts; however, no solutions to this problem.
Using the networkdays formula, I calculated the number of working days
between the due date and the completed date...

=NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18)

where K1=Date Complete (5/1/07)
G1=Due Date (5/1/07)

I would think the result of the formula would = 0, since the due date
and date complete are the same. Instead, the result is 1. Any
suggestions how I can count the number of days in between the 2 dates
to reflect Days Early/Late? Thanks in advance for your help.

-T

Number of working days between 2 dates
 

A couple of thoughts............if you want your formula to result in zero
when both dates are the same, try

=NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18)-1

or maybe just put =G1 as one of your holidays....

hth
Vaya con Dios,
Chuck, CABGx3



" wrote:

So I've seen similar posts; however, no solutions to this problem.
Using the networkdays formula, I calculated the number of working days
between the due date and the completed date...

=NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18)

where K1=Date Complete (5/1/07)
G1=Due Date (5/1/07)

I would think the result of the formula would = 0, since the due date
and date complete are the same. Instead, the result is 1. Any
suggestions how I can count the number of days in between the 2 dates
to reflect Days Early/Late? Thanks in advance for your help.

-T