DATE

• 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:

=DATE(year, month, day)

1. year (required):
   The year of the date you want to create. Must be a valid number greater than or equal to 1900.
2. month (required):
   The month of the date you want to create. Must be a valid number between 1 and 12.
3. day (required):
   The day of the date you want to create. Must be a valid number between 1 and 31.

Examples

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 date-based 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 date-based chart

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

Common Mistakes

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

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.