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

In Excel: November 4, 2001 becomes 11/04.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8=""Checks whether the birth date cell is empty.Not empty
2A8The real birth date.November 4, 2001
3"mm/dd"The pattern: two-digit month, then two-digit day."mm/dd"
4TEXT( … )Writes the month and day as text, with no year."11/04"
5IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own dates. Paste real birth dates into the green column of the Template tab. The birthdays fill in by themselves.
  3. 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