I want to format the date 'Tuesday, April 28th, 2020' to dd-mm-yy format in excel. How can I do that? I tried doing it with cell formatting but to no avail. I think custom formatting can help but I don't know how to use that.
1 Answers
I would follow @Scott Craner formula, and format it just like in the below picture.
Step 1: Enter formula click this picture link
Step 2: Format as "mm-dd-yy" in the cell formatting -> custom format click this picture link
Here is the result click this picture link
Related