Excel Age Calculator - Xls Download

Rashid Ahmed
Greetings,
Friends,
Find herewith attached excel tool.
Regards,
1 Attachment(s) [Login To View]

jiguparmar
Nice But U have Choosen Very long Formulas It is very simple
Ex.
Date:______ (in A2 cell) then
Age: =int((today()-A2)/365.25) will give u same Results...
Thanks... for various program on Excel visit... <link no longer exists - removed>
1 Attachment(s) [Login To View]

bhaveshj
Great job Rashid.
Another useful formula which will give u Age in Year, Month, Days.
Formula:
=DATEDIF(B1,TODAY(),"y")&"."&DATEDIF(B1,TODAY(),"y m")&"."&DATEDIF(B1,TODAY(),"md")
Paste this formula in excel sheet in B2 column.
Hope all find it useful.
Regards,
Bhavesh
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute