Navigation:  Formula Reference > Spreadsheet Formula Functions >

NOW

Previous pageReturn to chapter overviewNext page

 

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.

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

 

See Also

DATEVALUE

TIME