S SarahN Apr 30, 2010 #1 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
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 Apr 30, 2010 #2 Try the below formula =DATEVALUE(MID(A1,FIND(",",A1)+1,20)) OR try Data>Text to columns with "," delimiter
Try the below formula =DATEVALUE(MID(A1,FIND(",",A1)+1,20)) OR try Data>Text to columns with "," delimiter
