The DATE function in Excel returns a serial number representing a specific date when given year, month, and day arguments. Excel stores dates as sequential serial numbers so they can be used in calculations. DATEVALUE is for converting text dates, not constructing dates from components.