TODAY Function – Google Sheets

Help text for the TODAY function in Google Sheets

The TODAY function returns the current day’s value. The value is dynamic and updates when you change, refresh, or reopen your Google Sheet.

The TODAY function returns just the date. If you want the date and time, use the NOW function, which operates similarly but returns the time and date in the same value.

You can also insert the current date into a cell in Google Sheets using the shortcuts listed below. However, the values inserted with these shortcuts will not update like the TODAY function’s output.

  • Windows: ctl+;
  • Mac: ⌘+;

You can apply date formatting to the result by going to the Format menu, choosing Number, and then choosing Date.

Purpose

The TODAY function returns the value of the current day. As further explained in how to use dates and times in Google Sheets formulas, the value is an integer, but Google Sheets will typically display it as a date.

Syntax

=TODAY()

Note that you need the parenthesis even though they are empty.

Similar Functions

NOW – Returns the current date and time

app icon for TIMEDIF with a calendar and clock
TIMEDIF – Google Sheets Add-On

Calculate any duration in:

  • Years
  • Months
  • Weeks
  • Days
  • Hours
  • Minutes
  • Seconds
  • Milliseconds

Examples

Example 1 – Plain and Simple

Firstly, let’s look at some simple examples of the TODAY function.

FormulaDescriptionResult
=TODAY()Outputs today’s date which was September 22, 2022.9/22/2022
=TODAY()-1Returns yesterday’s date.9/21/2022

Example 2 – Calculating Age With the TODAY and YEARFRAC Functions

For the second example, let’s work with an inventory analysis. We use the YEARFRAC function to return the fractional number of years between two days. For example, in row 2, the purchase date was 2/12/2016 and “today’s” date is 9/22/2022. The time between them is 6.6 years.

You could add conditional formatting to make every cell with a value greater than 5 have a pink background and red font to show you that the inventory is obsolete.

Tip: Add the rounding function to display fewer decimals such as =ROUND(YEARFRAC(C2,TODAY())),0)

 ABCD
1Item #Purchase DateAge FormulaAge Value
2Hang glider – red striped2/12/2016=YEARFRAC(C2,TODAY())6.611111111
3Stunt bike6/30/2018=YEARFRAC(C3,TODAY())4.227777778
4Flaming Sword4/2/2017=YEARFRAC(C4,TODAY())5.472222222

Tip: The DATEDIF function provides a more robust method of calculating age. You can customize it to output days, months, years, or a combination thereof.

Example 3 – Three Months Ago

Now let’s get the date three months before today.

FormulaDescriptionResult
=EDATE(TODAY(),-3)Returns the date three months ago. Today’s date is September 22, 2022.6/22/2022

The EDATE function takes a start_date argument and a months argument. With a start_date of today’s date and a months value of -3, EDATE returns a value three months in the past.

Example 4 – Last Day of the Current Month

The TODAY and EOMONTH functions and can be used to find the last day of the current month.

FormulaDescriptionResult
=EOMONTH(TODAY(),0)Return the last day of the month.9/30/2022

The EOMONTH function accepts start_date and number_of_months arguments and returns the last day of the month a given number_of_months away from its start value. In this case, we used the current date as the start value and specified 0 months away. Therefore, it returns the end of the current month.

Live Examples in Sheets

Go to this spreadsheet for the examples of the TODAY function shown above that you can study and use anywhere you would like.

Video Explanation

YouTube player