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.

CodePudding user response：

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