Keep a year-only birth date as year text
Turn the birth year 2001 into the text 2001, with no made-up day or month.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks whether the birth year cell is empty. | Not empty |
| 2 | TEXT(A8,"0000") | Writes the year as text with four digits. | "2001" |
| 3 | IF( … ) | Shows nothing when the year cell is empty. | "2001" |
Read it left to right. Only the year is kept: no January 1 is made up.
=IF(A8="","",TEXT(A8,"0000"))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 years. Paste birth years into the green column of the Template tab. The year text fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Paste the year only, like 1980. A full date turns into a long number here.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Mark unrecognized date text for review
4-Nov-2026 → 11/04/2026; next week → Review date
Get the template →
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 →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →