Pivot table date grouping not working in Google Sheets?
DateFix normalizes text dates into real date values so your pivot table can group by day, month, quarter, and year correctly.
DateFix normalizes text dates into real date values so your pivot table can group by day, month, quarter, and year correctly.
Pivot tables cannot group dates stored as text. DateFix normalizes them into real date values so grouping by month, quarter, and year works correctly.
Built for imported data, broken date columns, regional ambiguity, and real-world spreadsheets that need reliable date output.
Once DateFix converts your text dates to real values, pivot table grouping by month, quarter, and year becomes available again.
DateFix works directly on the data range. Point your pivot table at the cleaned output column and grouping works correctly.
CSV files, CRM exports, form data. DateFix handles the inconsistent date formats that typically break pivot table grouping.
Run DateFix over your full date range in one formula and rebuild your pivot table against the normalized output.
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")
Date grouping only appears when Google Sheets recognizes the column values as real dates. If the dates are stored as text, grouping options are not available. DateFix converts the text values so grouping works correctly.
Point your existing pivot table at the new column containing DateFix output, or replace the original values with the normalized dates. Either approach restores grouping.
Yes. DateFix returns normalized date values by default. You can also use the ISO argument for ISO 8601 output, though standard date values work best for pivot table grouping.
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.
