DATEVALUE Function in Excel

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:

date value function in excel 1

Only last DATE_TEXT is not in Text format which will result in Error #VALUE!. So the Result will be

Results:

date value function in excel 2

  • 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

date value function in excel 3

So the Resultant Formatted table will be

date value function in excel 4

DATEVALUE Function in Excel                                                                                                                DATEVALUE Function in Excel