Write a years-and-months phrase
Turn November 4, 2026 to June 4, 2029 into 2 year(s), 7 month(s) for letters.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATEDIF(A8,B8,"Y") | Counts the whole years from the start date. | "2" |
| 2 | &" year(s), "& | Adds the word year(s) and a comma. | "2 year(s), " |
| 3 | DATEDIF(A8,B8,"YM") | Counts the months past the last whole year. | "2 year(s), 7" |
| 4 | &" month(s)" | Adds the word month(s). | "2 year(s), 7 month(s)" |
Read it left to right. A8 is the start date and B8 the as-of date. A month counts once the same day comes round again.
=DATEDIF(A8,B8,"Y")&" year(s), "&DATEDIF(A8,B8,"YM")&" month(s)"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 as-of dates into the green columns of the Template tab. The phrases fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Put the start date first. Read a few phrases aloud before you send: 1 year(s) may need a small edit.
Microsoft's help: DATEDIF function
OTHER ROUTES YOU MIGHT LIKE

Find the next annual date for an event
November 4, 2026 and March 4, 2027 → November 4, 2027
Get the template →
Place an annual event into the as-of year
November 4, 2001 into January 15, 2026 → November 4, 2026
Get the template →
Find the most recent anniversary
November 4, 2001 and January 15, 2026 → November 4, 2025
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →