Excel or your CRM swaps day and month in dates (US vs EU format)

Why 03/04/2026 becomes April 3rd or March 4th and how to import dates reliably.

The message you see
Dates swapped: 03/04 becomes 4 March
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Find ambiguous dates →

Why this happens

How to fix it

  1. 1Use the unambiguous ISO format YYYY-MM-DD for imports.
  2. 2Check which rows are ambiguous before converting — don't let a tool guess.

Related guides

Still stuck? Ask SheetFix Support