![]() |
NETWORKDAYS = 0
I have a networkdays equation that equals zero sometimes and equals one other
times when the start and end dates are the same. All of my date fields are formatted as m/d/yyyy. start date end date #days 8/4/2005 8/4/2005 1 8/16/2005 8/16/2005 0 -- TIA, Ann |
Ann
it works OK for me. What formula are you using ? Have you got a holiday list defined anywhere that yo are picking up ? Regards Trevor "ann" wrote in message ... I have a networkdays equation that equals zero sometimes and equals one other times when the start and end dates are the same. All of my date fields are formatted as m/d/yyyy. start date end date #days 8/4/2005 8/4/2005 1 8/16/2005 8/16/2005 0 -- TIA, Ann |
My formula is =NETWORKDAYS(F940,G940) where F940 is start date and G940 is
end date. I am not bothering with holidays at this time. -- TIA, Ann "Trevor Shuttleworth" wrote: Ann it works OK for me. What formula are you using ? Have you got a holiday list defined anywhere that yo are picking up ? Regards Trevor "ann" wrote in message ... I have a networkdays equation that equals zero sometimes and equals one other times when the start and end dates are the same. All of my date fields are formatted as m/d/yyyy. start date end date #days 8/4/2005 8/4/2005 1 8/16/2005 8/16/2005 0 -- TIA, Ann |
I can't reproduce your problem. For me, with Excel 2003, both sets of dates
return 1. On Mon, 3 Oct 2005 11:25:09 -0700, ann wrote: My formula is =NETWORKDAYS(F940,G940) where F940 is start date and G940 is end date. I am not bothering with holidays at this time. |
Thanks to all who replied. It only happens intermittently so maybe it is
something with the spreadsheet. It is very old and has several anomalies. -- TIA, Ann "ann" wrote: I have a networkdays equation that equals zero sometimes and equals one other times when the start and end dates are the same. All of my date fields are formatted as m/d/yyyy. start date end date #days 8/4/2005 8/4/2005 1 8/16/2005 8/16/2005 0 -- TIA, Ann |
All times are GMT +1. The time now is 10:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com