Home/Formulas/Date/TODAY
Dateeasy

TODAY()

Returns the current date as a date value.

Syntax
fx
=TODAY()
Try it
F2
→
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Volatile: re-evaluates on every recalc, which may inflate Sheets file activity in shared documents.
  • Returns a date with no time component. Compare to NOW() if you need a timestamp instead.
Related formulas
NOW()
Returns the current date and time as a date value.
DATE()
Constructs a date value from year, month, and day numbers.
Used by
NOW()
Returns the current date and time as a date value.
DATE()
Constructs a date value from year, month, and day numbers.
More Date formulas →Keyboard shortcuts for Sheets →