Forum Discussion
Solved
Convert Day/Date/Time cell to Date Only?
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 wo...
The 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.
The 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.
Worked beatutifully. Thank you. Cheers.