Formulas > =DATE()

# How To Use DATE() Function in Google Sheets

Description

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

Common questions about the DATE formula:
-What is the syntax for the DATE formula?
-How does the DATE formula work?
-What parameters does the DATE formula take?

How can the DATE formula be used appropriately:
-The DATE formula can be used inside other formulas to help calculate future dates, such as repayment dates, deadlines, etc.
-It can also be used to convert unformatted dates to an accepted date format.

How can the DATE formula be commonly mistyped:
-It can be easily mistyped if the wrong parameters are used or if the syntax is written incorrectly.

What are some common ways the DATE formula is used inappropriately:
-Using it with potential incorrect inputs, such as mistyped values or a wrongly-formatted string.
-Attempting to format the dates with the DATE formula, rather than using a dedicated function for formatting.

What are some common pitfalls when using the DATE formula:
-Incorrectly using the DATE function when the DATEVALUE function is required.
-Using incorrect parameters in the syntax, such as an incorrect format for the date string.

What are common mistakes when using the DATE Formula:
-Incorrectly using the DATEVALUE function.
-Leaving out an essential parameter.
-Misstyping the format of the date string.

What are common misconceptions people might have with the DATE Formula:
-Thinking that the DATE formula can be used to format dates, when that feature is not present in the formula.
-Assuming that the DATE formula can be used to calculate future dates when the DATEVALUE function is needed instead.

How To Actually Use DATE() in Sheets

`DATE(year, month, day)`

2Better Sheets Tutorials

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.
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.

Generate a DATE() formula for your needs with AI

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets