DATE Function

Combines values for a year, month, and day into a date.
Sample Usage
DATE(2013, 10, 14)
Syntax
DATE(
  • year
  • month
  • day
)
  • year
    —
    The year component of the date, provided in YYYY format.
  • month
    —
    The month component of the date, provided in MM format.
  • day
    —
    The day component of the date, provided in DD format.
Usage Notes

You must use DATE in a Date column unless you're nesting it within another function, for example =IF(DATE(2017, 5, 29) = TODAY(), "Vacation!"). For more information, see the Column Types article.

Related Functions
DAY
MONTH
YEAR
Was this article helpful?
YesNo