DataValue Formula
|
|
Date
|
Date Value
|
|
|
|
|
25-dec-99
|
36519
|
=DATEVALUE(C4)
|
|
|
|
25/12/99
|
#VALUE!
|
=DATEVALUE(C5)
|
|
|
|
25-dec-99
|
36519
|
=DATEVALUE(C6)
|
|
|
|
25/12/99
|
#VALUE!
|
=DATEVALUE(C7)
|
|
|
|
|
|
|
|
|
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.
|
||||
|
|
|
|
|
|
|
|
|
Property Ref.
|
Expiry Date
|
Days Until Expiry
|
|
|
|
BC100
|
25-dec-99
|
-4292
|
|
|
|
FG700
|
10-july/99
|
-4460
|
|
|
|
TD200
|
13-sep-98
|
-4760
|
|
|
|
HJ900
|
30/5/2000
|
#VALUE!
|
|
|
|
|
|
=DATEVALUE(E32)-TODAY()
|