How to Use TODAY in Google Sheets

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

In short: TODAY returns the current date, with no time. The formula is =TODAY(). It takes no arguments and updates whenever the sheet recalculates.

What TODAY does

TODAY returns today's date, so a sheet can react to the calendar without anyone typing a date. Use it for due-date checks, age calculations and "days left" counters.

TODAY syntax

=TODAY()

TODAY takes no arguments, but the parentheses are required. Google's help page lists these notes:

A step-by-step example

Type this in any cell:

=TODAY()

The cell shows the current date. Open the same sheet tomorrow and it shows tomorrow's date.

Date arithmetic

Dates are numbers underneath, where one unit is one day, so you can add and subtract them. A date one week from now:

=TODAY() + 7

The number of days until a deadline stored in A2 is =A2 - TODAY(). If the cell shows a number in date format, change its format to a plain number.

Put the date in only once

Because TODAY changes, it is the wrong tool for a date stamp that must stay fixed, such as the day an order was placed. For that, type the date, or use the keyboard shortcut for the current date, which enters a fixed value.

Common mistakes

Try it yourself

Type your formula into the box, starting with =, then press Check.

Exercise 1: Today's date

Write a formula that returns today's date.

Hint: no arguments, but keep the parentheses.

Exercise 2: One week ahead

Write a formula that returns the date 7 days from today.

Hint: add 7 to TODAY().

What to learn next

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