Use a fallback date for missing dates

Use the preferred date. When it's blank, the backup date fills in instead.

What you'll make

In Excel: [blank] or January 1, 2027 becomes January 1, 2027.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8<>""Checks whether the preferred date is filled in.Filled in
2A8The preferred date, used when it's there.November 4, 2026
3IF(B8<>"",B8,"")Otherwise the backup date, or blank if none.Not used for row 8
4IF( … )Picks the preferred date first, then the backup.November 4, 2026

The preferred date always wins, even when the backup date is later. Both blank gives a blank.

=IF(A8<>"",A8,IF(B8<>"",B8,""))

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 preferred dates and backup dates into the green columns of the Template tab. Leave a cell empty when there's no date.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

A 0 in the preferred column counts as a date, not a blank. Clear it so the backup date is used.

Microsoft's help: IF function