Home/Formulas/Date/NOW
Dateeasy

NOW()

Returns the current date and time as a date value.

Syntax
fx
=NOW()
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: every edit triggers a recalc, so NOW updates constantly. Don't use it as a stable timestamp; use a static-paste or Apps Script trigger.
  • Returns a date AND time. To get only time, use MOD(NOW(), 1). To get only the date, use INT(NOW()).
Related formulas
TODAY()
Returns the current date as a date value.
DATE()
Constructs a date value from year, month, and day numbers.
Used by
TODAY()
Returns the current date as a date value.
More Date formulas →Keyboard shortcuts for Sheets →