|
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
|
-6249
|
|||
|
FG700
|
10-july/99
|
-6417
|
|||
|
TD200
|
13-sep-98
|
-6717
|
|||
|
HJ900
|
30/5/2000
|
#VALUE!
|
|||
|
=DATEVALUE(E32)-TODAY()
|
|||||
No comments:
Post a Comment