Aug 13 2021 09:39 AM
How can I convert the following cell of day, date, time to a simple date format?
Current Cell: Sat, Feb 06, 2021, 06:16PM
Goal Format: 2/6/2021
I tried the following formula, but it didn't work: =MONTH(A2)&"/"&DAY(A2)&"/"&YEAR(A2)
Aug 13 2021 09:55 AM
SolutionThe values in column A aret text. not date/time, so MONTH etc. won't work.
Enter the following formula in B2:
=DATEVALUE(MID(A2,10,2)&"-"&MID(A2,6,3)&"-"&MID(A2,14,4))
Format B2 as a date, then fill down.
Aug 13 2021 10:00 AM - edited Aug 13 2021 10:01 AM
Worked beatutifully. Thank you. Cheers.
Aug 13 2021 10:09 AM
Aug 13 2021 09:55 AM
SolutionThe values in column A aret text. not date/time, so MONTH etc. won't work.
Enter the following formula in B2:
=DATEVALUE(MID(A2,10,2)&"-"&MID(A2,6,3)&"-"&MID(A2,14,4))
Format B2 as a date, then fill down.