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?

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" wrote in message
...
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?