NOW()

Description

Returns the current date and time as a date value.

How To Use in Sheets

NOW()

External Links

Google Sheets – Using Dates and Times in Formulas

Dates and times need to be treated differently than plain numbers when using formulas in Google Sheets. There are three different ways that you can work with them to get the results that you want.