Sort by date not working in Google Sheets?
If your date column will not sort in chronological order, the dates are stored as text. DateFix converts them to real date values so sort, filter, and every date formula works the way it should.
If your date column will not sort in chronological order, the dates are stored as text. DateFix converts them to real date values so sort, filter, and every date formula works the way it should.
Text dates sort alphabetically, not chronologically. DateFix converts them to real date values so your column sorts in the correct order.
Built for imported data, broken date columns, regional ambiguity, and real-world spreadsheets that need reliable date output.
DateFix outputs real date values that Google Sheets can sort chronologically, not alphabetically.
Run DateFix over your full date range in a single formula and sort the output column.
CSV files, exports, form data. DateFix handles the inconsistent formats that typically cause sort problems.
Correct date values also fix date grouping in pivot tables and date axes in charts.
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")
Dates stored as text sort alphabetically rather than chronologically. A date like 2/1/2024 will appear before 12/1/2023 because the text character 2 comes before the character 1 in the second value. DateFix converts the values to real dates so sort order is correct.
Look at the cell alignment. Real dates right-align automatically. Text dates left-align. You can also try formatting the column as a date. If the display does not change, the values are text.
Yes. Pivot table date grouping by month, quarter, or year requires real date values. Once DateFix converts your text dates, grouping will work correctly.
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.
