NETWORKINGDAYS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NETWORKDAYS 2
6 Day working week (friday holiday) 2
changing weekends for NETWORKDAYS calculation 13
how do I multiply dollars by networkdays for forcasting run rates 6
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
Week starts on Saturday - Working days 8
networkingdays 4
Multiple IFs/Calc. Weeks 4

Back
Top