EU vs US date format ambiguity in Google Sheets?
A date like 04/05/2024 means two different things depending on where the data came from. DateFix lets you specify US or EU interpretation so ambiguous dates are always handled correctly.
A date like 04/05/2024 means two different things depending on where the data came from. DateFix lets you specify US or EU interpretation so ambiguous dates are always handled correctly.
A date like 04/05/2024 means two different things depending on region. DateFix lets you specify US or EU interpretation so ambiguous dates are always handled correctly.
Built for imported data, broken date columns, regional ambiguity, and real-world spreadsheets that need reliable date output.
Pass a third argument of US or EU to tell DateFix how to read ambiguous dates across the whole range.
Combine regional interpretation with ISO output, time normalization, or range-level processing in a single formula.
If your data includes both US and EU formatted dates, DateFix processes each cell individually while applying your specified rule to ambiguous values.
Get normalized date output ready for sorting, filtering, pivot tables, or export to databases and APIs.
Install the add-on, open it in your sheet, and use a simple formula in a new column.
Example formulas
=DATEFIX(A2:A100)
=DATEFIX(A2,"ISO")
=DATEFIX(A2,,"US")
Use the optional third argument: =DATEFIX(A2,,"EU") to interpret ambiguous dates as dd/mm/yyyy, or =DATEFIX(A2,,"US") for mm/dd/yyyy.
A date like 04/05/2024 is ambiguous because it could be April 5 or May 4. A date like 25/04/2024 is not ambiguous because 25 cannot be a month, so DateFix will always interpret it as dd/mm/yyyy regardless of the region argument.
DateFix will attempt to interpret each date using the most likely format based on the values present. For clearly ambiguous inputs, specifying US or EU gives you a predictable, consistent result.
DateFix is a Google Sheets add-on that helps clean and normalize messy or inconsistent date values with a simple custom function like =DATEFIX(A2:A10).
DateFix is free to use up to 100 rows per day. If that's insufficient, we offer an unlimited version for $19.99 / month, which allows an unlimited number of DateFix calls. You may upgrade within the DateFix add-on by clicking the upgrade button from the sidebar. Upgraded subscriptions may be cancelled at any time.
