The range of dates 01/12/2009 and 01/13/2009 contains two work days when one
counts inclusively
If you want an exclusive count use =NETWORKDAYS(I5,K5) -1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Ann 'Formula challenged'" <Ann 'Formula challenged'
@discussions.microsoft.com wrote in message
...
Hello, I struggle incorporating @IF formulas.
I have three date columns. I need to find the work days between any two
dates.
My challenge is when I use the following formula for the following dates:
K5 reflects 01/09/2009 and J5 reflects 01/09/2009 and I5 reflects
01/02/2009
I use the formula =NETWORKDAYS(J5,K5) the value comes to 1 and it should
be
zero.
I use the formula =NETWORKDAYS(I5,K5) the value comes to 6 and should be 5
Also another challenge I can't figure out:
K6 reflects 01/12/2009 and J5 reflects 01/13/2009
I use the formula =NETWORKDAYS(I5,K5) the value comes to (2) and should be
(1).
Thank you in advance for your help!!