Calculate completed months since birth
Turn November 4, 2026 and November 4, 2027 into 12 completed months.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The birth date. | November 4, 2026 |
| 2 | B8 | The date to count up to. | November 4, 2027 |
| 3 | "M" | Counts in whole months. | "M" |
| 4 | DATEDIF( … ) | Counts the months finished between the two dates. | 12 |
A month counts only once the same day of the month comes round again.
=DATEDIF(A8,B8,"M")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 birth 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
The as-of date must be on or after the birth date. Otherwise the row turns amber.
Microsoft's help: DATEDIF function
OTHER ROUTES YOU MIGHT LIKE

Get months past the last whole year
November 4, 2026 to June 4, 2029 → 7 months
Get the template →
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 →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →