Write a full letter date from date parts
Turn 2026, 11 and 4 into the words November 4, 2026 for a letter.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATE(A8,B8,C8) | Puts the year, month and day together as a date. | November 4, 2026 |
| 2 | "mmmm d, yyyy" | The pattern: month name, day, comma, year. | "mmmm d, yyyy" |
| 3 | TEXT( … ) | Writes the date in that pattern as text. | "November 4, 2026" |
The result is text for a letter, so it won't sort as a date.
=TEXT(DATE(A8,B8,C8),"mmmm d, yyyy")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 the year, month and day into the green columns of the Template tab. The letter dates fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
A month of 13 or a day of 32 rolls into the next month. Check any date that looks odd.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Write a month-year phrase from parts
2026 + 11 → November 2026
Get the template →
Convert only full birth dates
2001-11-04 → November 4, 2001; 2001-11 → Review
Get the template →
Format a birth date at known precision
1998 stays 1998; 2001-11 → November 2001
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →