How to get the month name from a date
✓ Verified in LibreOffice 25.8.7.3Turn a date into its month name, like "July", for reports and labels.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =TEXT(A2,"mmmm") | "mmm" gives the short form (Jul). |
| Google Sheets | =TEXT(A2,"mmmm") | Identical. |
| LibreOffice Calc | =TEXT(A2,"MMMM") | LibreOffice format codes are case-insensitive here; "mmmm" also works. |
How it works
TEXT formats a value using a format code: "mmmm" is the full month name, "mmm" the abbreviation, and "mm" the two-digit month number. The result is text, so it stays put when sorted or concatenated. Month names follow the spreadsheet's language setting — on a French locale you'd get "juillet".
Verified, not just documented
We ran =TEXT(DATE(2026,7,20),"MMMM") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned July — exactly the expected result. Every formula here is confirmed by actually executing it.