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