DATEVALUE Error for normal date format

[mexmanz]

Hi,

I am using the datevalue function to simply give the numeric value of a date column.

formula is =DATEVALUE(D1)

I am receiving the #Value! error on many cells which would appear to have a standard date in the excel system range.

Does not make sense, all formatting is the same for the date column

Some give the date value but some dates bring the error such as:

31/03/2008
11/04/2006
13/10/2006
11/10/2007
28/03/2008

I am running MSExcel 2003

Any explanation or fix for this please
thanks
Andrew

 

[VoG]

I think it is because those are real dates. Perhaps

=IF(ISERROR(DATEVALUE(A1)),A1,DATEVALUE(A1))

 

[barry houdini]

Perhaps just

=D1+0

format as date

 

[VoG]

Perhaps just

=D1+0

format as date

Forgot to activate brain before posting

 

[mexmanz]

Great Thanks