DATEVALUE (convert text into date value)

<< Click to Display Table of Contents >>

DATEVALUE (convert text into date value)

Syntax:

DATEVALUE(Text)

Description:

This converts a text string representing a date to a serial date value.

Note:

This function was retained only for compatibility with older spreadsheet applications. It is no longer commonly used, as current spreadsheet applications (including PlanMaker) automatically convert text representing a date to a serial date value if necessary.

Example:

DATEVALUE("09/25/2018") returns 43368.

If you now use the options of the ribbon tab Home | group Numbergroup_arrow to format this in one of the date/time formats (for example M/D/YYYY), the cell will display the date behind this value: the 9/25/2018.

See also:

TIMEVALUE, DATE, TIME