Sponsored Link
Purpose
Get the current date and time
Return value
A serial number representing a particular date and time in Excel.
Syntax
=NOW ()
Arguments
Usage notes
NOW takes no parameters but requires empty parentheses. The value returned by NOW will continually update each time the worksheet is refreshed (for example, each time a value is entered or changed). Use F9 to force the worksheet to recalculate and update the value.