NETWORKDAYS Calculation Problem

S

stacy

Hello...

I have a quick, and probably insanely easy question regarding the
calculation of NETWORKDAYS. I cannot get the following formula to
return a "0" value:

=IF(F23="",0,NETWORKDAYS(E23,F23,L$6:L$14)-SIGN(F23-E23))

E23 F23 G23
03/09/06 03/09/06 1

In G23, the formula above returns "1" and not "0". If I change F23 to
03/10/06, I get "1", which is correct. And if I change F23 to
03/08/06, I get "-1" which is correct. What am I missing??

Thanks in advance for what I am sure is a simple fix...
 

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

Top