Date and Time - DateSerial

Syntax:
=DateSerial(Optional Year, Optional Month, Optional Day)

Description:
Returns a date value for the specified year, month and day

Example:

Give the date of the 25th of June 2004. =DateSerial(2004,6,25)