=DATEVALUE(RIGHT($A$1,(LEN($A$1)-FIND(",",$A$1,1))))
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Max Bialystock" wrote:
Range("A1") contains the text string "Friday, 4 May 2007" as imported.
I need a routine that will convert "Friday, 4 May 2007" to 39206 (excel
date number).