[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

NOW

Syntax:

NOW ( )

Description: Computes the serial value of the current date and time, taking into account the current date base value.

Arguments: None.

Return Type and Value: number – The serial value of the current date and time.

[Example: On February 26, 2006, between 23:01 and 23:02, NOW() resulted in 38774.95958611110 for the 1900 date base system. On February 26, 2006, between 23:02 and 23:03, NOW() resulted in 37312.95982569440 for the 1904 date base system. end example]