software

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)

quot;rrobinsonquot; gt; wrote in message
...
gt; I am using NETWORKINGDAYS to find out the difference to when an item was
gt; order and when it was actually received. When the order date is the same
as
gt; the received date the answer I'm getting is one this should be zero as
there
gt; 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

quot;rrobinsonquot; gt; 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.