Spread Formula Reference
Formula Functions / Functions D to G / DATEVALUE
In This Topic
    DATEVALUE
    In This Topic

    This function returns the serial number of a date entered as text.

    Syntax

    DATEVALUE(date_string)

    Arguments

    The argument for this function is a date as a string.

    Remarks

    Use this function to convert a date represented by a text string to an Excel serial number that can be used to perform calculations.

    Data Types

    Accepts string data. Returns an excel serial number as date.

    Examples

    DATEVALUE(B18)

    DATEVALUE(R18C2)

    DATEVALUE("2019/02/13") gives the result 43509.

    Version Available

    This function is available in product version 1.0 or later.

    Note: If a user uses LegacyBehaviors.CalculationEngine, DATEVALUE 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 | TIMEVALUE | Date and Time Functions