Share this article:

What it does: The DATE() formula returns the serial number that represents a particular date.

Plain English: This formula returns the serial number of the year, month, and date provided.

Arguments: DATE(year,month,day)

  • Year – What year?
  • Month – Which month?
  • Day – What day?