All functions / Date & Time
DATE
Builds a date from a year, month and day.
Syntax
=DATE(year, month, day)
Arguments
year: The year, e.g. 2025.month: The month, 1-12 (larger numbers roll into later years).day: The day of the month.
Example
=DATE(2025, 7, 4) → 2025-07-04