Excel Function : DATEVALUE
Category
Date and time
Description
Converts a date in the form of text to a serial number
Microsoft Excel Reference Page
https://support.office.com/en-us/article/DATEVALUE-function-df8b07d4-7761-4a93-bc33-b7471bbff252
Syntax and Description of the DATEVALUE Excel Function
The syntax for the DATEVALUE function in Microsoft Excel is: DATEVALUE( date_text ) date_text is a text representation of a date.
About DATEVALUE Excel Function
The DATEVALUE function in Excel converts a date that is stored as text into a date that is recognized by Excel as a date. This is useful if you have a date stored in a text format that you want to use in a calculation.
