Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / TODAY
In This Topic
    In This Topic

    This function returns a serial number representing the current date in Excel. The results are updated as soon as the worksheet is opened or refreshed.




    This function does not accept arguments.


    If you use this function in a date-time cell (DateTimeCellType), the cell formats the value using the date format settings.

    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 (a serial number) that represents the current date in Excel.


    If today is the 13th of February in the year 2019, then

    TODAY() gives the result 43509.

    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, TODAY function will return the DateTime object instead of the serial numeric value.

    See Also

    DATE | DAY | NOW | TIME | Date and Time Functions