Better Sheets

How to Use DATE() in Google Sheets

Description

Converts a provided year, month, and day into a date.

How To Actually Use DATE() in Sheets

DATE(year, month, day)

Try DATE yourself

In cell A1, use the DATE() formula to create a date for January 15, 2023. The correct answer must display the date in a recognizable format.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

How Many Days Between Two Dates?

Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.

Intermediate

DATE() DATEDIF()

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.

CONCAT() DATE() MONTH() VALUE()

Transcript-matched member videos for 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()

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including...

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...

Beginner

COUNTA() COUNTIF() IF() SPARKLINE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Unlock these tutorials

Learn more about the DATE() formula:

Generate a DATE() formula for your needs

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

Generate a DATE() formula