How to Use the DATE Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: DATE turns a year, month and day into a date. The formula is =DATE(year, month, day). Out-of-range months and days roll over, so DATE(2026,13,1) is January 1, 2027.

What DATE does

Typing a date straight into a formula is risky, because Sheets may read 10/10/2000 as a division. DATE builds a real date from three separate numbers, so the result is always unambiguous and works as input for other date functions.

DATE syntax

=DATE(year, month, day)

Per Google's help page:

A step-by-step example

To make Christmas Day 2026:

=DATE(2026, 12, 25)

This returns December 25, 2026. Here is why: the three numbers are read as year, month and day, in that order. Many people expect day first. Always use year, month, day.

The numbers can come from cells. Here the year, month and day are stored in separate cells A2, B2 and C2:

ABC
1YearMonthDay
22026315
=DATE(A2, B2, C2)

This returns March 15, 2026.

Rollover: months and days that overflow

Google's page states that out-of-range values roll over into the next period. DATE(1969,13,1) becomes January 1, 1970, and DATE(1969,1,32) becomes February 1, 1969. This makes DATE useful for arithmetic. DATE(2026, 12, 31 + 1, ...) is awkward, but =DATE(2026, 3, 0) gives the last day of February, because day 0 rolls back one day from March 1.

Common DATE mistakes

Try it yourself

Use the cells above for exercise 2. Type your formula into the box, starting with =, then press Check.

Exercise 1: Christmas Day

Write a formula that returns December 25, 2026 using DATE.

Hint: year first, then month, then day.

Exercise 2: Date from cells

Write a formula that builds a date from the year in A2, the month in B2 and the day in C2.

Hint: DATE(A2, B2, C2).

What to learn next

Syntax and rules in this guide were checked against Google's DATE help page. See all guides.