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.
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.
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.
|Property Ref.||Expiry Date||Days Until Expiry|