What does now() mean in excel
NOW returns the serial number corresponding to the current date and time. If the cell is formatted as "General" before entering the function, the result will be formatted as a date.
Syntax
NOW( )
Description
Microsoft Excel can store dates as available for Calculated serial number. By default, the serial number for January 1, 1900 is 1 and the serial number for January 1, 2008 is 39448 because it is 39448 days from January 1, 1900. Microsoft Excel for the Macintosh uses an alternative default date system.
The number to the right of the decimal point in the serial number represents the time, and the number to the left represents the date. For example, a sequence number of .5 indicates the time is 12:00 noon.
Function NOW only changes when the worksheet is recalculated, or when a macro containing this function is executed. It is not updated at any time.
Using
For more Excel-related technical articles, please visit the Excel Tutorial Column to learn!
The above is the detailed content of What does now() mean in excel?. For more information, please follow other related articles on the PHP Chinese website!