DATE(Year, Month, Day)

Year (required) – This is the year number from 1900 to 9999.Month (required) – This is the month number from 1 to 12.Day (required) – This is the day number from 1 to 31.


In this example we create a few dates by reference to a year, month and day. Notice that if we use a month greater than 12 or a day greater than the actual number of days in the month, then the result rolls over into the next month or year.

DATE function - 79