TODAY Function in Google Sheets

Get the current date using the TODAY function in Google Sheets.

TODAY Function

The TODAY function in Google Sheets returns the current date.

Syntax

TODAY()

Examples

  1. Basic Usage

To display the current date in a cell:

=TODAY()
  1. Using in Calculations

To find the number of days from the current date to a future date in cell B1:

=B1 - TODAY()

Notes

  • The value returned by TODAY changes every time the spreadsheet is opened or recalculated.
  • Useful in calculating durations and age.
  • NOW: Returns the current date and time.
  • DATE: Returns a date based on year, month, and day inputs.