Excel Tips - Tip 10 (How to calculate exact Age)

Hello,

Hope my excel tips are helping you out.

Here is the Tenth tip for you. Hope this help you.

As this is the season of Filing Income tax return and depositing of taxes, we often have to find the age of the assessee to calculate the exact amount of tax as per Income Tax Act, 1961 .

How to Calculate Age with Formulae :

You can calculate a persons age based on their birthday and todays date

The calculation uses the DATEDIF() function..

Birth date :	01-Jan-60		Formulae Used
Years lived :	55	=DATEDIF(C8,TODAY(),"y")
and the months :	8	=DATEDIF(C8,TODAY(),"ym")
and the days :	7	=DATEDIF(C8,TODAY(),"md")

You can put this all together in one calculation, by using my earlier tip ‘using & Key’ and the formulae is

="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"

And the outcome is 

Age is 55 Years, 8 Months and 7 Days

Note : The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.

Hope the Tip is useful to you and the same is clear.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/alreadyresponded?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456