Forum Discussion
relaunch96
Aug 13, 2021Copper Contributor
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...
- Aug 13, 2021
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.
HansVogelaar
Aug 13, 2021MVP
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.
- relaunch96Aug 13, 2021Copper Contributor
Worked beatutifully. Thank you. Cheers.