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
