Networkdays problem

[JamesDMartin]

Hi
I'm trying to use the network days function to calculate how many day
there are between today() and a list of project deadlines.

The function i'm using is *NETWORKDAYS($N$2,E3)*
Where $N$2 is a cell containing the function *Today()* returning today
date. and the E column contains the project dead lines

Cell N2 and the E column are formatted as CUSTOM d/m/yy (UK)

As an example of the problem if todays date N2 is 29/03/05
And the E column contains 30/5/2005 the figure returned is 14
If the E column contains 14/4/2005 the figure returned is 13
If the E column contains 14/6/2005 the figure returned is 25
If the E column contains 21/6/2005 the figure returned is 1

Its all over the place.

I've tried changing the Format of the cells to the US format i.e
mm/dd/yy but the format makes no odds.

Ive tried removing the function *today()* from N2 and replacing it wit
a date, same problem.

I dont think its the way i have put the formula in, i think it ha
somthing to do with the settup of the spreadsheet.

Can anyone sugest what the problem is?

Regards
Jame

 

[Ron Rosenfeld]

Hi
I'm trying to use the network days function to calculate how many days
there are between today() and a list of project deadlines.

The function i'm using is *NETWORKDAYS($N$2,E3)*
Where $N$2 is a cell containing the function *Today()* returning todays
date. and the E column contains the project dead lines

Cell N2 and the E column are formatted as CUSTOM d/m/yy (UK)

As an example of the problem if todays date N2 is 29/03/05
And the E column contains 30/5/2005 the figure returned is 14
If the E column contains 14/4/2005 the figure returned is 13
If the E column contains 14/6/2005 the figure returned is 25
If the E column contains 21/6/2005 the figure returned is 1

Its all over the place.

I've tried changing the Format of the cells to the US format i.e.
mm/dd/yy but the format makes no odds.

Ive tried removing the function *today()* from N2 and replacing it with
a date, same problem.

I dont think its the way i have put the formula in, i think it has
somthing to do with the settup of the spreadsheet.

Can anyone sugest what the problem is?

Regards
James

Date input parsing is determined by your regional settings, not by the Excel
format. The Excel format only determines how the input is displayed.

As a test, try entering the dates unambiguously. Such as:

=DATE(2005,5,30)
=DATE(2005,4,14)
=DATE(2005,6,14)
=DATE(2005,6,21)

=TODAY() in N2 is unambiguous

If that gives correct answers, then check under your Windows regional settings
(or the equivalent if you're using a different OS) that your date settings are
the way you are entering your data.


--ron