Related Functions:

The DATEVALUE function converts a text string representing of a date, into a serial number that represents the date in Excel’s date-time code. 

Syntax

=DATEVALUE(date_string)

Arguments

Argument Description
date_string Text that represents a date in an Excel date format, or a reference to a cell that contains text that represents a date in an Excel date format

Note: If the year portion of the date_string argument is omitted, the DATEVALUE function uses the current year from your computer’s built-in clock. Time information in the date_string argument is ignored.

Examples

  A B C
1 Data    
2 1    
3 2    
4 2014    
5      
6 Formula Result Notes
7 =DATEVALUE(“01/02/2014”) 41641 Serial number of a date entered as text
8 =DATEVALUE(“02-Jan-2014”) 41641 Serial number of a date entered as text
9 =DATEVALUE(“2-Jan”) 41641 Serial number of a date entered as text, using the 1900 date system, and assuming the computer’s built-in clock returns 2014 as the current year
10 =DATEVALUE(A2&”/”&A3&”/”&A4) 41641 Serial number of a date created by combining the values in cells A2, A3, and A4

Usage note: If date_string is a cell address, the value of the cell must be text. If date_string is entered directly into the formula it must be enclosed in quotes.

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied date_string cannot be recognized as a valid Excel date

  The date_string refers to a cell that does not contain a date formatted as text
  The date_string entered directly into the function is not enclosed in quotes