The DATE function is one of the date and time functions. It is used to add dates in the default format MM/dd/yyyy.
Syntax
DATE(year, month, day)
The DATE function has the following arguments:
Argument | Description |
---|
year | A numeric value representing the year (four digits). |
month | A numeric value representing the month (from 1 to 12). |
day | A numeric value representing the day (from 1 to 31). |
Notes
How to apply the DATE function.
Examples
The figure below displays the result returned by the DATE function.
