DATEVALUE Function in Excel, converts a date in text format to a Serial Number that represent particular date in Excel.
Syntax for DATEVALUE Function in Excel
=DATEVALUE(date_text)
DATEVALUE Function in Excel takes up date_text as an Argument
NOTE: Excel DATEVALUE Function Takes up only Text value as Argument, if not #VALUE! Will be returned
Example of DATEVALUE Function in Excel
Formula:
Only last DATE_TEXT is not in Text format which will result in Error #VALUE!. So the Result will be
Results:
- First DATE_TEXT contains only date and month so current year (2017) is used for Date value calculation.
- Date Value Equivalent of 3/1/2015 is 42064
- As Excel Base date is 1/1/1900 the resultant date will be 1.
- Last DATE_TEXT is not in Text format so result will be #VALUE!
Formatting the cells to Display Dates
If you want to display the result column in date format then select result column. On Home tab click the dropdown and select short date as shown below
So the Resultant Formatted table will be