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