Excel Function : DATEVALUE

Download now!

Excel Function : DATEVALUE


Date and time


Converts a date in the form of text to a serial number

Microsoft Excel Reference Page


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.