NOW
Description
Returns the current date and time as a time zone independent (UTC) value. This
function is volatile; it generates a new value any time any cell in the workbook
changes.
Syntax
NOW()
Example
Formula | Result |
|---|---|
=NOW() | 10/4/2016 5:37 PM (current time) |
Notes
- The function doesn't run as a volatile function if the Worksheets calculation mode is set toManualin .
- The NOW() function returns the user's current time. The workbook time, shown when you select the Info icon on the Worksheets main page, shows the time based on the browser time (web) or the device time (mobile).