Returns the current date and time as a date value.
Description
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.