Show the full month name from a date
Turn the date November 4, 2026 into the month name: November.
What you'll make

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | A8 | The real date. | November 4, 2026 |
| 2 | "mmmm" | The pattern: the month's full name. | "mmmm" |
| 3 | TEXT( … ) | Writes the month name as text. | "November" |
Four m's give the full name. Three, "mmm", give a short one like Nov.
=TEXT(A8,"mmmm")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own dates. Paste real dates into the green column of the Template tab. The month names fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
The result is text, not a date. Month names follow your Excel language, so they may not be English.
Microsoft's help: TEXT function



