Skip to content

The basics · Lesson 7 of 10

Why 03/04/2026 Is Two Different Dates

The same date written with slashes means 4 March in the United States and 3 April in most other countries. How to tell which one you have, and the fix.

One invoice, two dates

An invoice arrives dated 03/04/2026. If it was written in the United States, it is from March 4, 2026. If it was written in Britain, France, India or Australia, it is from April 3, 2026. The digits are the same and the dates are a month apart.

Read the American way: month, then day.
You type
03/04/2026
The converter shows
March 4, 2026 MMMM D, YYYY · clock kept as written · no timezone conversion

Open in the converter: 03/04/2026 → March 4, 2026

Read the way most of the world does: day, then month.
You type
03/04/2026
The converter shows
April 3, 2026 MMMM D, YYYY · clock kept as written · no timezone conversion

Open in the converter: 03/04/2026 → April 3, 2026

Who writes which order

  • Month first (month/day/year): the United States, and often Canada and the Philippines.
  • Day first (day/month/year): most other countries, including the UK, the rest of Europe, Latin America, India, Australia and most of Africa.
  • Year first (year-month-day): China, Japan, Korea, and computers everywhere.

Each order follows the way people say the date. Americans say “March fourth”, and the British say “the third of April”.

How to tell which one you have

Look for a number above 12. There are only twelve months, so a number from 13 to 31 has to be the day. 25/12/2026 can only be December 25, 2026.

If both numbers are 12 or less, the date alone cannot tell you. About four dates in every ten are like this. Use what is around it:

  • Other dates in the same list or file. One date with a 13 or higher shows the order for all of them.
  • Where it came from: the country of the sender, the website or the program.
  • Whether the result makes sense. An invoice dated three months in the future was probably read the wrong way round.

A two-digit year makes it worse. Something like “03/04/05” can be read three ways, and nothing in it says which.

The fix: year first

ISO 8601, the international standard, puts the largest unit first: year, then month, then day, with hyphens.

  • The American reading is written 2026-03-04.
  • The day-first reading is written 2026-04-03.

No country reads a year-first date with the day and month swapped, so it has one meaning everywhere. It also sorts correctly: put a list of these dates in alphabetical order and they are in date order.

A year-first date reads one way only.
You type
2026-04-03
The converter shows
April 3, 2026 MMMM D, YYYY · clock kept as written · no timezone conversion

Open in the converter: 2026-04-03 → April 3, 2026

When you write for people rather than computers, spelling the month as a word works just as well: “3 April 2026” and “April 3, 2026” cannot be confused.

Spreadsheets swap them silently

Excel and Google Sheets read a slashed date by the region set on your computer or account. Open a file from another country and every date with a day of 12 or less is read the other way round, with no warning. The dates with a higher day stay as text, so the column ends up half wrong. How to fix dates where the day and month are swapped goes through the repair.

Try it

Open the date in the converter. It shows one reading and offers the other beside it, so you can see both before you choose.

Open the day-first reading

Where to go next