Clean and normalize messy dates in Google Sheets™.

DateFix helps you quickly fix date format values in spreadsheets and CSV imports. If you’ve ever opened a dataset and found dates written in multiple formats, DateFix lets you clean and normalize them in seconds with a simple function.

Instead of manually correcting dates or writing complicated formulas, you can standardize them with one formula applied to a single cell or an entire column.

WHY DATEFIX IS USEFUL

When data comes from different systems, exports, or collaborators, dates often appear in multiple formats such as:

October 21, 2010
10/21/2010
21 Oct 2010
2010-10-21
10/21/2010 11:30
Oct 21 2010 11:30 AM

DateFix interprets these variations and returns a clean, consistent result that works correctly with sorting, filtering, and calculations.

NORMALIZE DATES IN A SINGLE CELL

Use the DATEFIX function to clean and normalize a date in any cell.

Example:
=DATEFIX(A2)

DateFix detects many common date formats automatically and converts them into a consistent format.

NORMALIZE AN ENTIRE COLUMN OF DATES

DateFix works with ranges, so you can clean entire datasets at once.

Example:
=DATEFIX(A2:A1000)

This allows you to normalize hundreds or thousands of rows of date data with one formula.

EXTRACT OR NORMALIZE TIMES

If you want to normalize time values from mixed inputs, use the TIME option.

Example:
=DATEFIX(A2,"TIME")

This returns consistent time values from inputs that contain time information.

OUTPUT ISO-FORMATTED DATES

If you need machine-readable dates for exports or integrations, use the ISO option.

Example:
=DATEFIX(A2,"ISO")

This returns dates in ISO format such as:

2010-10-21
2010-10-21 11:30

ISO formatting is useful when preparing data for APIs, databases, or other systems.

RESOLVE AMBIGUOUS DATE FORMATS BY REGION

Some dates can be interpreted differently depending on location. For example:

10/11/2024

This could mean October 11 or November 10 depending on the region.

DateFix lets you specify how these dates should be interpreted.

Example:
=DATEFIX(A2,, "US")
Interprets ambiguous dates as month/day/year.

Example:
=DATEFIX(A2,, "EU")
Interprets ambiguous dates as day/month/year.

COMMON USE CASES

DateFix is useful for many spreadsheet workflows, including:

• Cleaning imported CSV files
• Fixing inconsistent date columns
• Preparing datasets for analysis
• Normalizing historical data
• Converting dates for exports or integrations

Instead of manually correcting dates or writing complex formulas, use DateFix to normalize your spreadsheet data quickly and reliably.