This function returns the current date and time.
NOW()
This function does not accept arguments.
This function is updated only when the spreadsheet or cell containing the function is recalculated. This is a volatile function.
Does not accept data. Returns a DateTime object.
If it is 05:10:00 P.M., November 11, 2004, then:
NOW() gives the result November 11, 2004, 5:10pm