Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

NOW

Description: Returns the current date and time in the form of a serial number.

Syntax: NOW( )

Remarks:

The software stores times as decimal fractions because time is considered a portion of a day.

Because dates and times are values, they can be added, subtracted and included in other calculations. You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.

Because the rules that govern the way that any calculation program interprets dates are complex, you should be as specific as possible about dates whenever you enter them. This will produce the highest level of accuracy in your date calculations.

Example:

NOW() = 31778.52083

NOW() = 31778.52778

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.