How to Insert the Current Date and Time in Google Sheets With NOW
=NOW() returns the current date and time. It takes no arguments and updates whenever the spreadsheet recalculates. For the date alone, use TODAY.
What NOW does
NOW returns the current date and time as a single date value. It is used for timestamps in reports, countdowns and "last viewed" displays.
NOW syntax
=NOW()
NOW takes no arguments, but the parentheses are required. Google's help page makes these points:
- NOW is volatile. It updates on every edit made to the spreadsheet, which can hurt performance in large sheets.
- It always shows the date and time from the last recalculation, not the moment you typed the formula.
- To get only the date, use TODAY.
- If the date or time seems to be missing, change the cell's number format. The portion may just be hidden.
The page does not say which time zone NOW uses.
A step-by-step example
=NOW()
This shows the current date and time. To show only the time, as text, wrap it in TEXT with a pattern from Google's TEXT page:
=TEXT(NOW(), "HH:mm")
This returns the hours and minutes on a 24-hour clock, for example 14:35. The mm after the hours is read as minutes.
A fixed timestamp
Because NOW keeps changing, it cannot record when something happened. For a timestamp that stays put, copy the cell and paste it as values only.
Common mistakes
- Forgetting the parentheses. Write
NOW(), notNOW. - Expecting a fixed time. It changes whenever the sheet recalculates.
- Overusing it. Many NOW formulas in a large sheet slow it down.
Try it yourself
Type your formula into the box, starting with =, then press Check.
Exercise 1: Right now
Write a formula that returns the current date and time.
Exercise 2: Just the time
Write a formula that shows the current time as text in the form HH:mm.
What to learn next
- TODAY: return the current date.
- TEXT: format numbers and dates as text.
- DATE: build a date from a year, month and day.
- TIME and HOUR: build a time and read its hour.
Syntax and rules in this guide were checked against Google's NOW help page. See all guides.