Jul 27 2021 04:37 AM
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 |
Jul 27 2021 04:45 AM
Text to Columns shall work if you assign proper format on 3rd step
Result is
(I use ISO date format)