What Does It Do?
The function is used to convert a piece of text into a date which can be used in calculations. Dates expressed as text are often created when data is imported from other programs, such as
exports from mainframe computers.
Syntax
=DATEVALUE(text)
Formatting
The result will normally be shown as a number which represents the date. This number can be formatted to any of the normal date formats by using Format,Cells,Number,Date.