<< Click to Display Table of Contents >> DATEVALUE (convert text into date value) |
Syntax:
DATEVALUE(Text)
Description:
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, where necessary.
Example:
DATEVALUE("09/25/2018") returns 43368.
If you now format this using the options of the ribbon tab Home | group Number 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: