If your dates won't sort, filter, or work in pivot tables, Date Fix converts them to real dates with one formula.

Dates from CSV files, CRM exports, or pasted from PDFs and webpages often appear as text. They look right but don't behave like dates. Date Fix standardizes them to a consistent format.

FIX A SINGLE CELL
---------------------------------
=DATEFIX(A2)

Date Fix converts text to date in Google Sheets™ -- standardizing across any format including:
October 21, 2010
10/21/2010
21 Oct 2010
2010-10-21
Oct 21 2010 11:30 AM

FIX AN ENTIRE COLUMN
-----------------------------------------
=DATEFIX(A2:A1000)

Standardize hundreds or thousands of rows at once.

HANDLE US AND EU DATE FORMATS
--------------------------------------------------------------
Some dates are ambiguous. 10/11/2024 could mean October 11 or November 10 depending on where the data came from. 

Tell DateFix which convention to use:
=DATEFIX(A2, ,"US") interprets as month/day/year
=DATEFIX(A2, ,"EU") interprets as day/month/year

OUTPUT ISO-FORMATTED DATES
-------------------------------------------------------
=DATEFIX(A2,"ISO") returns 2010-10-21 (for dates) or 2010-10-21T21:54:00-05:00 (for datetimes).

The ISO 8601 format for dates is YYYY-MM-DD (e.g., 2010-10-21), which uses a 4-digit year, 2-digit month, and 2-digit day, separated by hyphens. For datetime values its YYYY-MM-DDTHH:MM:SSZ (e.g., 2026-04-29T16:06:06Z). DateFix will output either, which is useful for exports, APIs, or database imports. 

STANDARDIZE TIME VALUES
-------------------------------------------------
=DATEFIX(A2,"TIME")

Extracts and standardizes the time from mixed inputs.

COMMON USE CASES
* Make Google Sheets™ sort by date work every time
* Fix date columns exported from Salesforce, HubSpot, or other CRMs
* Convert text to date in Google Sheets™
* Get time from datetime values
* Clean CSV exports before pivot tables or analysis
* Clean up dates pasted from websites, ERPs, or other tools
* Standardize / normalize columns with mixed or international date formats
* Convert dates to ISO format
* Prepare dates for APIs or database imports
* Flag values that are not dates from a column
* Extract time from any date