How to Use TODAY in Google Sheets
=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:
- It returns only the date. For the date and the time, use NOW.
- The result reflects the date at the most recent recalculation, not the date the formula was entered.
- TODAY is a volatile function and can hurt spreadsheet performance, so avoid filling thousands of cells with it.
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
- Leaving out the parentheses. Write
TODAY(), notTODAY. - Using it as a permanent timestamp. It updates every time.
- Wrong format on the result. A subtraction may display as a date. Switch the cell to a number format.
- Overusing it. Many volatile cells can slow a large sheet.
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.
Exercise 2: One week ahead
Write a formula that returns the date 7 days from today.
What to learn next
- IF: run a test and return one of two results.
- COUNTIFS: count rows that meet several conditions.
- IFERROR: replace an error with a clean result.
- EOMONTH: return the last day of any month.
- NOW: returns the current date and time.
Syntax and rules in this guide were checked against Google's TODAY help page. See all guides.