How to Use TO_DATE() in Google Sheets

Description

Converts a provided number to a date.

How To Actually Use TO_DATE() in Sheets

TO_DATE(value)

Try TO_DATE yourself

In cells B1:B10, enter numbers representing dates (e.g., 44561 for January 1, 2023). Use the TO_DATE formula in cell C1 to convert the number in B1 to a date. Drag the formula down to fill C2:C10.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for TO_DATE(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...

Advanced

IF() REGEXMATCH()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your da...

Intermediate

IF() ISBLANK() SUBSTITUTE()

Unlock these tutorials

Learn more about the TO_DATE() formula:

Generate a TO_DATE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses TO_DATE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a TO_DATE() formula