What is the Syntax of DATE function in Excel?

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


=DATE (year, month, day)


  • year - Number for a year.
  • month - Number for month.
  • day - Number for day.