Functions
DATE
Creates a date serial number from year, month, and day
Try it
When to use it
When should I use DATE instead of typing a date directly?
Use DATE to build a date from separate year, month, and day numbers, which is reliable across locales and lets you compute dates from calculated parts.
What happens if I pass a month greater than 12 to DATE?
DATE rolls the extra months into the year, so DATE(2024, 13, 1) becomes January 1, 2025.
Use cases
Roll forward one month using month overflow
Get the day-of-month from a constructed date
Used in
finance · operations · hr
Syntax
DATE(year,month,day)Examples
=DATE(2026,6,7) // => 46180
=DATE(2026,6,7)+1 // => 46181
=DATE(2026,6,7)-DATE(2026,6,1) // => 6