DATE
TheDATE
formula is used to create a date object in Google Sheets. It takes three arguments: year, month, and day and returns a date. This formula is useful when you need to perform date calculations or create datebased charts and graphs.
 How to use
DATE
formula?  Examples of using
DATE
formula DATE
formula not working? Similar formulas to
DATE
Usage
Use the DATE
formula with the syntax shown below, it has 3 required parameters:
 year (required):
The year of the date you want to create. Must be a valid number greater than or equal to 1900.  month (required):
The month of the date you want to create. Must be a valid number between 1 and 12.  day (required):
The day of the date you want to create. Must be a valid number between 1 and 31.
Examples
Here are a few example use cases that explain how to use theDATE
formula in Google Sheets.
Create a date in a cell
Use the DATE
function to create a date in a cell by specifying the year, month, and day. This is useful when you need to perform date calculations or create datebased charts and graphs.
Calculate the number of days between two dates
Use the DATE
function to create two dates, then subtract one from the other to calculate the number of days between them.
Create a datebased chart
Use the DATE
function to create a series of dates, then use them as the xaxis for a chart. This is useful when you want to visualize data over time.
Common Mistakes
DATE
not working? Here are some common mistakes people make when using the DATE
Google Sheets Formula:
Incorrect use of quotation marks
When using the DATE formula, make sure to use the correct quotation marks around your arguments. Use straight quotes (" ") instead of curly quotes or other symbols.
Invalid arguments
Make sure to provide valid arguments for the DATE formula. For example, the year argument should be a fourdigit number and the month argument should be a number between 1 and 12.
Incorrect order of arguments
Make sure to provide the arguments for the DATE formula in the correct order: year, month, day. Otherwise, you may get unexpected results.
Related Formulas
The following functions are similar to DATE
or are often used with it in a formula:

TODAY
The
TODAY
function returns the current date in the default timezone of the spreadsheet. The date is updated each time the spreadsheet is opened. This function is commonly used to calculate the current age or to track the number of days since a certain event, among other things. 
DATEDIF
The
DATEDIF
function in Google Sheets calculates the difference between two dates using a specified unit of measurement. This function is commonly used to calculate the length of time between two dates, such as the number of days, months, or years. The function is particularly useful when working with financial or project planning data. 
EOMONTH
The
EOMONTH
function returns the date of the last day of the month that is the indicated number of months before or after the start date. This function is commonly used to calculate due dates, expiration dates, and other dates relative to a specified start date. 
WEEKDAY
The
WEEKDAY
formula takes a given date and returns the day of the week it represents, as a number ranging from 1 (Sunday) to 7 (Saturday). This function is most commonly used to calculate the day of the week for a given date and to perform calculations or comparisons based on the day of the week.
Learn More
You can learn more about the DATE
Google Sheets function on Google Support.