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


--
JamesDMartin
------------------------------------------------------------------------
JamesDMartin's Profile: http://www.msusenet.com/member.php?userid=272
View this thread: http://www.msusenet.com/t-3344333