Calculate completed years since birth
Turn November 4, 2026 to November 4, 2036 into 10 years.
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 as-of date, the day you count to. | November 4, 2036 |
| 3 | "Y" | Counts whole years only. | Years |
| 4 | DATEDIF( … ) | Counts the birthdays reached between the two dates. | 10 |
Read it left to right. A year counts only once the birthday is reached. February 29 birthdays count on March 1 in other years.
=DATEDIF(A8,B8,"Y")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 ages fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Put the birth date first. If it comes after the as-of date, the row turns amber.
Microsoft's help: DATEDIF function
OTHER ROUTES YOU MIGHT LIKE

Calculate completed months since birth
November 4, 2026 to November 4, 2027 → 12 months
Get the template →
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 →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →