.

DATEVALUE Function Dictionary

Function Dictionary Function Examples Function Categories

DATEVALUE    
 
 
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 -5888
FG700 10-july/99 -6056
TD200 13-sep-98 -6356
HJ900 30/5/2000 #VALUE!
 =DATEVALUE(E32)-TODAY()

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download