What is the formula for date format in Excel? - Excel Tips and Tricks

Discover what is the formula for date formatting excel? We will also answer how you can date formatting in Excel. Also we will be answering how do I change the date formatting Excel to MMM DD YYYY? We also provide answer to why won't my date format change in Excel, and how do I get Excel to recognize a date?

These are the formulas outlined in this video.

Day of the week
Short Format
=TEXT(A2,"ddd")

Long Format
=TEXT(A2,"dddd")

Month
Short Format
=TEXT(A2,"mmm")

Long Format
=TEXT(A2,"mmmm")

Year
Short Format
=TEXT(A2,"yy")

Long Format
=TEXT(A2,"yyyy")


Date Format
=TEXT(A2,"dddd, d mmm yyyy")

Date Formatting,
What is the formula for date format in Excel?,How do I change the date format in Excel to MMM DD YYYY?,Why won't my date format change in Excel?,How do I get Excel to recognize a date?,