Write a named period from two dates
Turn two dates into November 1 through November 30, 2026 for letters and notices.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXT(A8,"mmmm d") | Writes the start month and day, no year. | "November 4" |
| 2 | &" through "& | Adds the word through between the dates. | "November 4 through " |
| 3 | TEXT(B8,"mmmm d, yyyy") | Adds the end date with its year. | "… November 30, 2026" |
Read it left to right. Each & joins the next piece on.
=TEXT(A8,"mmmm d")&" through "&TEXT(B8,"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 start dates and end dates into the green columns of the Template tab. The periods fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Keep both dates in the same year. Only the end date's year is shown.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Show a birthday without the birth year
November 4, 2001 → 11/04
Get the template →
Show the current date on filled records
Ava Reed → November 5, 2026
Get the template →
Convert variable-width year-first dates
2026-11-4 → November 4, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →