ExcelBanter - Converting TEXT to Date format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Converting TEXT to Date format (https://www.excelbanter.com/excel-discussion-misc-queries/262817-converting-text-date-format.html)

SarahN

Converting TEXT to Date format

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

Jacob Skaria

Converting TEXT to Date format

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

SarahN

Converting TEXT to Date format

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

All times are GMT +1. The time now is 08:18 PM.