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.
- You type
03/04/2026- The converter shows
March 4, 2026MMMM D, YYYY · clock kept as written · no timezone conversion
- You type
03/04/2026- The converter shows
April 3, 2026MMMM D, YYYY · clock kept as written · no timezone conversion
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.
- You type
2026-04-03- The converter shows
April 3, 2026MMMM D, YYYY · clock kept as written · no timezone conversion
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.
Where to go next
- How to Fix Dates Where the Day and Month Are Swapped: how-to: repairing a whole column that was read the wrong way
- Date Format Cheat Sheet: guide: which countries and programs write which order
- YYYY-MM-DD format: the year-first format, in full