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.

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

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

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