How to Insert the Current Date and Time in Google Sheets With NOW

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 4 min read · includes 2 free exercises

In short: =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:

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

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.

Hint: no arguments, but keep the parentheses.

Exercise 2: Just the time

Write a formula that shows the current time as text in the form HH:mm.

Hint: wrap NOW() in TEXT.

What to learn next

Syntax and rules in this guide were checked against Google's NOW help page. See all guides.