Microsoft Excel Tips

Dear All,

Hope you will be fine. I am starting new blog about Microsoft excel tips. In this blog I will provide you new excel tips & formulas on daily basis.
First note the index which i will teach you daily lesson by lesson.

Lesson NO: 01

Age Calculation

You can calculate a persons age based on their birthday and todays date.
The calculation uses the DATEDIF() function.
The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.
(Makes you wonder what else Microsoft forgot to tell us!)

Birth date :	12-Nov-03
Years lived :	6	=DATEDIF(C8,TODAY(),"y")
and the months :	3	=DATEDIF(C8,TODAY(),"ym")
and the days :	13	=DATEDIF(C8,TODAY(),"md")
You can put this all together in one calculation, which creates a text version.
Age is 6 Years, 3 Months and 13 Days
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"
Another way to calculate age
This method gives you an age which may potentially have decimal places representing the months.
If the age is 20.5, the .5 represents 6 months.
Birth date :	1-Jan-60
Age is :	50.15	=(TODAY()-C23)/365.25