DATE function

Category:Date and time

Name in English:DATE

That makes?

Gets the serial number that represents the specified date.

Syntax

DATE (year, month, day)

  • year (Required ): Number that represents the year of the date.
  • month (Required ): Number that represents the month of the date.
  • day (Required ): Number that represents the day of the date.

Examples

DATE (2010,6,25) = 40354
DATE (2011,3,30) = 40632

Leave a Comment