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

In Excel: April 11, 2026 becomes November 4, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesFor row 8
1A8The date with month and day swapped.April 11, 2026
2YEAR( … )Keeps the year as it is.2026
3DAY(A8)Uses the day as the month.11
4MONTH(A8)Uses the month as the day.4
5DATE( … )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.

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