SCHOOL BOOKS


SCHOOL BOOKS




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










Tamilnadu School Books Change for Academic Years


Standards


Academic year




2, 7, 10 & 12


2019-20


3, 4, 5 & 8


2020-21





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

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 plus1 all books free download, Tamilnadu 11th all books free download