The DATE function forms a date from values that represent the year, month, and day. 

DATE(Year, Month, Day)

ArgumentData typeDescription
YearNumberA four-digit number that represents the year.
MonthNumberA number between 1 and 12 that represents the month.
DayNumberA number between 1 and 31 that represents the day.

The DATE function returns a date.

The format used to display the date depends on your OS/browser settings. For example, the U.S. date format displays the month before the day (mm/dd/yyyy).

  • The month must be a number between 1 and 12, inclusive.
  • The day must be a number between 1 and 31, inclusive.
  • The values must represent a valid date (01/01/1900 —12/31/2399).

DATE

You can enter values directly into the DATE formula, or reference line items or list properties that are number formatted. 

FormulaDescriptionResult for U.S. date format
DATE(2018, 12, 25)This example shows how you can enter values directly into your formula.12/25/2018
DATE(Previous Year, Start Month, 3)This example shows how you can reference line items or list properties in your formula.03/01/2017
DATE(2018.3, 2.65, 8.4)This example shows how the DATE function will round to the nearest whole number.03/08/2018