Skip to Content

DATE

Returns the sequential serial number that represents a particular date

Syntax

DATE(year, month, day)

Parameters

  • year: Required. The value of the year argument can include one to four digits
  • month: Required. A positive or negative integer representing the month of the year from 1 to 12
  • day: Required. A positive or negative integer representing the day of the month from 1 to 31

Example

=DATE(2024, 1, 15)
Returns: Date serial numberSince: Excel 2003