Question about the =NETWORKDAYS FUNCTION?

S

Shemot3467

I aiming trying to calculate the lag between 2 dates. I have several questions.

1. I am using the =NETWORKDAYS function, but I am finding that if I receive
something on 07/04/06 and I send it out on 07/04/06, it is giving me a lag of
1. Shouldn't the lag be zero?

2. I need to calculate the lag but I do not want to include the start date?
 
B

Bob Phillips

This is because NETWORKDAYS calculates the number of days between two
dates, including the final date. To ncalculatre lag, just subtract 1.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Shemot3467 said:
I aiming trying to calculate the lag between 2 dates. I have several questions.

1. I am using the =NETWORKDAYS function, but I am finding that if I receive
something on 07/04/06 and I send it out on 07/04/06, it is giving me a lag of
1. Shouldn't the lag be zero?

2. I need to calculate the lag but I do not want to include the start
Click to expand...
date?
 
Top