Builds a date from separate year, month and day values.
DATE(year, month, day)
Date & Time.
=DATE(2026,8,15)
Returns Aug 15, 2026
Builds a date from year, month and day values.
It normalises overflow rather than erroring: DATE(2026,13,1) is January 2027, which is useful deliberately and confusing accidentally.