The DATE function forms a date from values that represent the year, month, and day.
Syntax
DATE(Year, Month, Day)
Arguments
| Argument | Data type | Description |
| Year | Number | A four-digit number that represents the year. |
| Month | Number | A number between 1 and 12 that represents the month. |
| Day | Number | A 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
Examples
You can enter values directly into the DATE formula, or reference line items or list properties that are number formatted.
| Formula | Description | Result 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 |
