The DATE function in Excel takes three number arguments (year, month, and day) and combines them to return a date. You can remember the order of the arguments because they go from largest unit to smallest.
For example, to return the date February 5th, 2012 type the following formula:
=DATE(2012, 2, 5)