Use Of Datevalue
Date
|
Date Value
| |
25-dec-99
|
36519
|
=DATEVALUE(C4)
|
25/12/99
|
36519
|
=DATEVALUE(C5)
|
25-dec-99
|
36519
|
=DATEVALUE(C6)
|
25/12/99
|
36519
|
=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
|
-6305
|
FG700
|
10-july/99
|
-6473
|
TD200
|
13-sep-98
|
-6773
|
HJ900
|
30/5/2000
|
-6148
|
=DATEVALUE(E32)-TODAY()
|
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें