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


DATEDIF Function Dictionary

Function Dictionary Function Examples Function Categories
FirstDate SecondDate Interval Difference
1-Jan-60 10-May-70 days 3782  =DATEDIF(C4,D4,"d")
1-Jan-60 10-May-70 months 124  =DATEDIF(C5,D5,"m")
1-Jan-60 10-May-70 years 10  =DATEDIF(C6,D6,"y")
1-Jan-60 10-May-70 yeardays 130  =DATEDIF(C7,D7,"yd")
1-Jan-60 10-May-70 yearmonths 4  =DATEDIF(C8,D8,"ym")
1-Jan-60 10-May-70 monthdays 9  =DATEDIF(C9,D9,"md")
What Does It Do?          
This function calculates the difference between two dates.
It can show the result in weeks, months or years.
FirstDate : This is the earliest of the two dates.
SecondDate : This is the most recent of the two dates.
"Interval" : This indicates what you want to calculate.
These are the available intervals.
"d" Days between the two dates.
"m" Months between the two dates.
"y" Years between the two dates.
"yd" Days between the dates, as if the dates were in the same year.
"ym" Months between the dates, as if the dates were in the same year.
"md" Days between the two dates, as if the dates were in the same month and year.
No special formatting is needed.
Birth date : 1-Jan-60
Years lived : 56  =DATEDIF(C8,TODAY(),"y")
and the months : 1  =DATEDIF(C8,TODAY(),"ym")
and the days : 6  =DATEDIF(C8,TODAY(),"md")
You can put this all together in one calculation, which creates a text version.
Age is 56 Years, 1 Months and 6 Days
 ="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"


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