ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   NETWORKDAYS = 0 (https://www.excelbanter.com/excel-discussion-misc-queries/48307-networkdays-%3D-0-a.html)

ann

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

Trevor Shuttleworth

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




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





Myrna Larson

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.


ann

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 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com