Navigation:  Formulas and functions > Functions from A to Z > NOW (current date and time)

Syntax:

NOW()

Description:

This returns the current date and time.

The displayed value is dynamic, so it is automatically updated when the document is opened.

Note:

The result is a number – like all dates in a spreadsheet. Calculate automatically formats it in time format so that it will be displayed as a time.

However, the result also contains the date. Thus, if you format the cell using the dialog box of the ribbon tab Home | group Number , for example, in the number format MM/DD/YYYY hh:mm, the current date and time will be displayed.

See also:

TODAY, CREATEDATE