DATE Function in Google Sheets

Creates a date value from year, month, and day components.

DATE Function

The DATE function creates a date value from year, month, and day components.

Syntax

DATE(year, month, day)
  • year: The year of the date (can be a two-digit or four-digit year).
  • month: The month of the date (1 for January through 12 for December).
  • day: The day of the date (1 through 31).

Examples

  1. Basic Example

Create a date for January 15, 2024:

=DATE(2024, 1, 15)
  1. Invalid Month Handling

If the month is greater than 12 or the day exceeds the number of days in the month, the DATE function adjusts the date accordingly.

Notes

  • This function is useful for creating and manipulating date values in Google Sheets.
  • TODAY: Returns the current date.