Spread.NET 17 Formula Reference
Formula Functions / Functions M to Q / NOW
In This Topic
    In This Topic

    This function is used to determine the current date and time. It returns a serial number that represents the current date and time in Excel. The results are updated each time a worksheet is opened or refreshed.




    This function does not accept arguments.


    This function is updated only when the spreadsheet or cell containing the function is recalculated. This is a volatile function with version 2.5 or later.

    Data Types

    Does not accept data. Returns a numeric value.


    If it is 04:50:00 P.M. , February 14, 2019, then:

    NOW() gives the result 43510.70174

    Version Available

    This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.

    Note: If a user uses LegacyBehaviors.CalculationEngine, the NOW function will return the DateTime object instead of the serial numeric value. .

    See Also

    DATEVALUE | TIME | Date and Time Functions