DATEformula 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 date-based charts and graphs.
- How to use
- Examples of using
DATEformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
DATEformula in Google Sheets.
Create a date in a cell
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 date-based charts and graphs.
Calculate the number of days between two dates
DATE function to create two dates, then subtract one from the other to calculate the number of days between them.
Create a date-based chart
DATE function to create a series of dates, then use them as the x-axis for a chart. This is useful when you want to visualize data over time.
DATEnot working? Here are some common mistakes people make when using the
DATEGoogle 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.
Make sure to provide valid arguments for the DATE formula. For example, the year argument should be a four-digit 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.
The following functions are similar to
DATE or are often used with it in a formula:
TODAYfunction 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.
DATEDIFfunction 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.
EOMONTHfunction 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.
WEEKDAYformula 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.
You can learn more about the
DATE Google Sheets function on Google Support.