Thankyou you have just saved me from manually converting 1852 dates!!!!

"Jacob Skaria" wrote:

Try the below formula

=DATEVALUE(MID(A1,FIND(",",A1)+1,20))

OR try DataText to columns with "," delimiter

--
Jacob (MVP - Excel)


"SarahN" wrote:

Ok so I have dates that have been written in as

Wednesday, 3 May 2009 not in 03/03/2009 format. Is there anyway of getting excel to recognise this as a date. I have tried to format as a date. (I am trying to use Date FIlters)

Thanks in advance