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.

DATE Function