Convert To Date

[Fayezsamea]

Hi Excel Sheet GODS,

I am trying to convert below data to date in excel but i couldn't do it with (Datevalue & Text to columns), any other solutions from your side

Thu, 2003-08-28

Fri, 2006-07-28

Sat, 2006-08-05

Tue, 2008-07-01

Sat, 2009-05-16

Wed, 2003-01-01

Mon, 2011-10-24

[#2]

@Fayezsamea 

Text to Columns shall work if you assign proper format on 3rd step

Result is

(I use ISO date format)