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.