Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multi NetWorkDays Calculation | Excel Worksheet Functions | |||
NetWorkdays Calculation isn't working | Excel Worksheet Functions | |||
NETWORKDAYS calculation returns inconsistent results | Excel Worksheet Functions | |||
Help with Networkdays Calculation | Excel Worksheet Functions | |||
NETWORKDAYS problem | Excel Programming |