Excel, DATEVALUE() Function
The DATEVALUE() function receives as input a text string representing a date. The function returns as output the date value corresponding to the input date text string. Jump To: Syntax Basic Example Why? More Examples – Syntax: =DATEVALUE(Date_Text) Date_Text: A text string representing a date. – Basic Example: