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 Number
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: