Question about the =NETWORKDAYS FUNCTION?

[Guest]

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?

 

[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)

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?