DATE(year, month, day)

The DATE function calculates a date code for the given year, month and day. For example, the formula:

DATE(97, 8, 8)

produces the date code 35649 or 8th August 1997, depending on your number format.

See also:

Other date functions