NETWORKINGDAYS
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.
|