How to Get Month from Date in Excel?

Use `=MONTH(A1)` to return the month number from a date in cell A1

Use `=TEXT(A1,”mmmm”)` to return the full month name

Use `=TEXT(A1,”mmm”)` to return the abbreviated month name

Use `=MONTH(DATEVALUE(A1))` if the date is stored as text

Use `=TEXT(A1,”mm”)` to return the month as two digits

Use `=CHOOSE(MONTH(A1),”January”,”February”,”March”,”April”,”May”,”June”,”July”,”August”,”September”,”October”,”November”,”December”)` to return the month name

Format the cell with a custom date format like `mmmm` or `mmm` to display the month name without changing the value

Suggested for You

Trending Today