Show a birthday without the birth year
Turn the birth date November 4, 2001 into the text 11/04. Empty cells stay blank.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks whether the birth date cell is empty. | Not empty |
| 2 | A8 | The real birth date. | November 4, 2001 |
| 3 | "mm/dd" | The pattern: two-digit month, then two-digit day. | "mm/dd" |
| 4 | TEXT( … ) | Writes the month and day as text, with no year. | "11/04" |
| 5 | IF( … ) | Shows nothing when the birth date cell is empty. | "11/04" |
Read it left to right. The year is only hidden here: the full date stays in column A.
=IF(A8="","",TEXT(A8,"mm/dd"))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 real birth dates into the green column of the Template tab. The birthdays fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
The full birth date stays in the green column. Remove that column before you share the list.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Show the current date on filled records
Ava Reed → November 5, 2026
Get the template →
Write a named period from two dates
11/4/2026 to 11/30/2026 → November 4 through November 30, 2026
Get the template →
Count dates shared by two periods
November 4–10, 2026 and November 10–20, 2026 → 1 shared date
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →