On Thu, 15 Nov 2007 13:13:57 -0500, "T. Valko" wrote:

March 3 2007 (or Mar 3 2007) is not a valid date string in the U.S., either!
U.S. regional format - m/d/yyyy

DATEVALUE = #VALUE!

However, these are valid:

Mar 3, 2007
March 3, 2007

It seems the comma makes all the difference!

--
Biff
Microsoft Excel MVP

The comma does NOT make a difference if your regional settings are
English(United Kingdom). Still get the #VALUE! error
--ron