View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stacy[_2_] stacy[_2_] is offline
external usenet poster
 
Posts: 30
Default NETWORKDAYS Calculation Problem

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