DATE

Creates a date from separate year, month, and day values. Use year, month, day order.

Function syntax

DATE(year, month, day)

Arguments:

• year: The year value.
• month: The month value.
• day: The day of the month.

Examples

• DATE(2030, 6, 15) - Returns 06/15/2030.
• DATE(C2, C3, C4) - Returns a date using C2 as the year, C3 as the month, and C4 as the day.
• DATE(MAX(year{}), MIN(month_num{}), month_day_num{!1}) - Returns a date from the maximum year, minimum month, and first day value across the respective fields.