DATE function

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.