How can we help?
Returns the current date and time as a date value.
NOWis a volatile function, updating on every edit made to the spreadsheet, and can hurt spreadsheet performance.
NOWprovides the current date and time. To create a date without the current time, use
NOWwill always represent the current date and time the last time the spreadsheet was recalculated, rather than remaining at the date and time when it was first entered.
TODAY: Returns the current date as a date value.
DATEVALUE: Converts a provided date string in a known format to a date value.
DATE: Converts a provided year, month, and day into a date.