Hi there experts,
I have a 6 digit date format that I want to switch to dd-mmm-yyyy
My date format looks like 080216 (Aug 08 2016)...... I need to look like, 08-Aug-2016
I have tried everything I know. I need help.
Thanks so much.
Microsoft Excel
Last Comment
Subodh Tiwari (Neeraj)
8/22/2022 - Mon
Subodh Tiwari (Neeraj)
There are two ways to achieve this..
Assuming your date string is in A2, then
1) try the formula =DATE("20"&RIGHT(A2,2),LEFT(A2,2),MID(A2,3,2)) and custom format the formula cells with dd-mmm-yyyy. Advantage of this method is excel will treat your dates as real dates.
2) Or try the formula =TEXT(DATE("20"&RIGHT(A2,2),LEFT(A2,2),MID(A2,3,2)),"dd-mmm-yyyy")
chris pike
ASKER
Thanks for the try.
I tried both formulas, neither one is working for me.
Roy Cox
CHIP PEARSON has an excellent Function for this here
Assuming your date string is in A2, then
1) try the formula =DATE("20"&RIGHT(A2,2),LEF
2) Or try the formula =TEXT(DATE("20"&RIGHT(A2,2