This function returns the current date and time.
Syntax
NOW()
Arguments
This function does not accept arguments.
Remarks
This function is updated only when the spreadsheet or cell containing the function is recalculated. This is a volatile function with version 2.5 or later.
Data Types
Does not accept data. Returns a DateTime object.
Examples
If it is 05:10:00 P.M., November 11, 2004, then:
NOW() gives the result November 11, 2004, 5:10pm
Version Available
This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.
See Also
DATEVALUE | TIME | Date and Time Functions