DATEVALUE

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.

Example

The example uses the =DATEVALUE and the =TODAY functions to calculate the number of
days remaining on a property lease.

The =DATEVALUE function was used because the date has been entered in the cell as
a piece of text, probably after being imported from an external program.