Google Sheets Function

DATE

Returns the serial number of a particular date.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

DATE(year, month, day)

The DATE function creates a valid date value from individual year, month, and day components. It is particularly useful when date components are stored in separate cells or generated by other formulas.

Arguments

yearrequiredThe year component, typically a 1-4 digit number.
monthrequiredThe month of the year, represented by a number from 1 to 12.
dayrequiredThe day of the month, represented by a number from 1 to 31.

Examples

=DATE(2023, 12, 25)

Result: 2023-12-25

Returns the date for December 25, 2023.

FAQ

What happens if the month is greater than 12?

The function adds that number of months to the first month of the specified year.

Related functions

TODAY NOW YEAR MONTH DAY