EXAM TIME TABLE 2018 -- +2 +1 10TH

Tamilnadu School Books Change for Academic Years


Academic year

2, 7, 10 & 12


3, 4, 5 & 8


STD - 1
STD - 2
STD - 3
STD - 4
STD - 5
STD - 6
STD - 7
STD - 8
STD - 9
STD - 10
STD - 11
STD - 12


DATEVALUE Function Dictionary

Function Dictionary Function Examples Function Categories

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.
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
BC100 25-dec-99 -5888
FG700 10-july/99 -6056
TD200 13-sep-98 -6356
HJ900 30/5/2000 #VALUE!


Popular posts from this blog

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

Tamilnadu plus1 all books free download, Tamilnadu 11th all books free download