NETWORKINGDAYS

R

rrobinson

I am using NETWORKINGDAYS to find out the difference to when an item was
order and when it was actually received. When the order date is the same as
the received date the answer I'm getting is one this should be zero as there
is no days in between.
 
B

Bob Phillips

NETWORKDAYS is inclusive, so just subtract 1 from the result.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
N

Niek Otten

This has been reported and discussed here often. It really is a matter of what you're used to.
If your definition is that it should be zero, subtract one.

--
Kind regards,

Niek Otten

|I am using NETWORKINGDAYS to find out the difference to when an item was
| order and when it was actually received. When the order date is the same as
| the received date the answer I'm getting is one this should be zero as there
| is no days in between.
 
Top