Spread 8.0 Documentation
NOW
Support Options
Formula Reference > Built-In Functions > NOW

Glossary Item Box

NOW


Name

Now

Description

Returns the serial value of the current date and time.

Syntax

NOW( )

Remarks

This function does not accept arguments.

The NOW function changes only when the spreadsheet or cell containing the function is recalculated.

Spread's calc engine processes dates as a numeric value in the form x.y, where x is the "number of days since December 30, 1899" and y is the fraction of day. Numbers to the left represent the date, which is the value that the DATE function returns. Use the TIME function to return the serial value for the time value (the fraction of a day).

Date values are based on the number of days elapsed since December 30, 1899, which has a date serial value of Day 0. For example, December 31, 1899 has a date serial value of 1. Date values prior to December 30, 1899 have negative date serial values. For example, the date value December 29, 1899 has a date serial value of –1.

See also DATE, DAY, HOUR, MINUTE, MONTH, SECOND, TIME, TODAY, WEEKDAY, and YEAR.

Data Type

Does not accept data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

If it is 05:10:00 P.M., November 11, 2000, then:

NOW() = 36841.7152777778

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.