Combine a name and date of birth
Turn Ava Reed and November 4, 2026 into Ava Reed (DOB: 11/04/2026).
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The name. | "Ava Reed" |
| 2 | OR(B8="",B8=0) | Checks for an empty date or a 0 placeholder. | No |
| 3 | " (DOB: "&TEXT( … )&")" | Writes the date as 11/04/2026 inside a label. | " (DOB: 11/04/2026)" |
| 4 | IF( … ) | Adds the label after the name only if part 2 says no. | "Ava Reed (DOB: …)" |
Read it left to right. With no date, or a 0, you get only the name.
=A8&IF(OR(B8="",B8=0),""," (DOB: "&TEXT(B8,"mm/dd/yyyy")&")")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 names. Paste names into column A of the Template tab and real birth dates into column B. Leave the date empty when you don't have one.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
The date is written month first, US style. Check that your readers expect 11/04 to mean November 4.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Write a date range without repeats
December 31, 2026 to December 31, 2026 → December 31, 2026
Get the template →
Write a full US-style date for a letter
November 4, 2026 → November 4, 2026 as text, 0 → blank
Get the template →
Write a full day-first date for a letter
November 4, 2026 → 4 November 2026, 0 → blank
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →