Now (Returns the serial number of the current date and time)

What Does It Do?

This function shows the current date and time. The result will be updated each time the worksheet is opened and every time an entry is made anywhere on the worksheet.

Syntax

=NOW()

Formatting

The result will be shown as a date and time. If it is formatted to show as a number the integer part is used for the date and the decimal portion represent the time.