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.](/assets/template-story/use-a-fallback-date-for-missing-dates-make.png)
The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8<>"" | Checks whether the preferred date is filled in. | Filled in |
| 2 | A8 | The preferred date, used when it's there. | November 4, 2026 |
| 3 | IF(B8<>"",B8,"") | Otherwise the backup date, or blank if none. | Not used for row 8 |
| 4 | IF( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Read the date from a text timestamp
2026-11-04T14:30:15Z → November 4, 2026
Get the template →
Convert a date following a colon label
DOB: 4-Nov-2026 → November 4, 2026
Get the template →
Convert dates with nonbreaking spaces
Nov[NBSP]4,[NBSP]2026 → November 4, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →