DATE function

Returns the date represented by year, month, and day formatted according to the short date style in the system's Regional Settings. The values for year, month, and day reflect the Gregorian calendar.

Syntax

DATE(year,month,day)

Example 1

DATE(1999,6,7)

Returns the value representing 6/7/1999.

Example 2

DATE(1999,6,7) + 4 ed.

Returns the value representing 6/11/1999.

Example 3

FORMAT(DATE(1999,10,14),"C")

Returns the value representing Tuesday, October 14, 1999.