Converting TEXT to Date format

S

SarahN

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)
Click to expand...

Thanks in advance
 
J

Jacob Skaria

Try the below formula

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

OR try Data>Text to columns with "," delimiter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dd/mm/yy if i change to some other format 2
Date issues 1
Date Format not working 2
How to set the cell for date? 7
Convert Date string to date format 7
Date Calculation problem 4
Split Date 8
Help with date difference 1

Top