Spread Formula Reference
Formula Functions / Functions T to Z / TODAY
In This Topic
    TODAY
    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.

    Syntax

    TODAY()

    Arguments

    This function does not accept arguments.

    Remarks

    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.

    Examples

    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. For more details, please refer to breaking changes for legacy behaviors.

    See Also

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