DATE

The DATE function returns the serial number that represents a particular date.

Syntax

=DATE(year, month, day)

Parameters

• year: The year component of the date (1900-9999)
• month: The month component of the date (1-12)
• day: The day component of the date (1-31)

Examples

=DATE(2023, 12, 25) // Returns the serial number for December 25, 2023
=DATE(2024, 1, 1) // Returns the serial number for January 1, 2024