Correct a confirmed month/day reversal
Turn April 11, 2026, imported with month and day swapped, back into November 4, 2026.
What you'll make

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | A8 | The date with month and day swapped. | April 11, 2026 |
| 2 | YEAR( … ) | Keeps the year as it is. | 2026 |
| 3 | DAY(A8) | Uses the day as the month. | 11 |
| 4 | MONTH(A8) | Uses the month as the day. | 4 |
| 5 | DATE( … ) | Puts the year, month and day back into a date. | November 4, 2026 |
Read it from the inside out: YEAR, DAY and MONTH work first, then DATE builds the fixed date.
=DATE(YEAR(A8),DAY(A8),MONTH(A8))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 the swapped dates into the green column of the Template tab. The fixed dates fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This swaps every date you paste, even right ones. Paste only dates you've checked were swapped.
Microsoft's help: DATE function
OTHER ROUTES YOU MIGHT LIKE

Convert MMDDYYYY text into a date
11042026 → November 4, 2026
Get the template →
Convert a 1904 date number to a date
1904 date number 44868 → November 4, 2026
Get the template →
Convert date text with an apostrophe
'4-Nov-2026 → November 4, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →