Get months past the last whole year
Turn November 4, 2026 to June 4, 2029 (2 years and 7 months) into 7.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The start or birth date. | November 4, 2026 |
| 2 | B8 | The date to count up to. | June 4, 2029 |
| 3 | "YM" | Counts months, leaving out whole years. | "YM" |
| 4 | DATEDIF( … ) | Gives the months finished since the last whole year. | 7 |
2 years and 7 months gives 7. A month counts once the same day comes round again.
=DATEDIF(A8,B8,"YM")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 months fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This gives only the months left over after whole years, never more than 11. Use it next to a years count.
Microsoft's help: DATEDIF function
OTHER ROUTES YOU MIGHT LIKE

Write a years-and-months phrase
November 4, 2026 – June 4, 2029 → 2 year(s), 7 month(s)
Get the template →
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 →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →