1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. DATE

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

Syntax

DATE(Year, Month, Day)

Arguments

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.

Additional information

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

Constraints

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

Excel equivalent

DATE(opens external page)

Examples

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