The Excel DATE function creates a valid date from the individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet.
- Purpose: Create a date with year, month, and day
- Return value: A valid Excel date
Syntax
=DATE (year, month, day)
Arguments
- year - Number for a year.
- month - Number for month.
- day - Number for day.