asked on Excel date formats not working.
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.
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)
ASKER
Thanks for the try.
I tried both formulas, neither one is working for me.
![date format]()
I tried both formulas, neither one is working for me.
CHIP PEARSON has an excellent Function for this here
ASKER
Roy,
Sorry limited VBA skills here.
Does the code go into "ThisWorkbook" or in "new module"
And how do i run it?
Thanks
Sorry limited VBA skills here.
Does the code go into "ThisWorkbook" or in "new module"
And how do i run it?
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi,
pls try
pls try
=TEXT(DATE("20"&RIGHT(A2,2),LEFT(A2,LEN(A2)-4),MID(TEXT(A2,"000000"),3,2))),"dd-mmm-yyyy")
ASKER
Thank you very much.
Works great.
Works great.
ASKER
Sorry Rgonzo I just awarded Neeraj before I saw your post.
You're welcome Chris! Glad to help.
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