Formulas > =DATE()
How To Use DATE() Function in Google Sheets
Description
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.
Hints (2)
-
Remember the order of year, month, and day in the DATE function.
-
Make sure to use commas to separate the arguments.
2 Better Sheets Tutorials
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.
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.
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()
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