Age Calculator or How to Know Your Age in Excel

Friends

Age Calculator 

             To know or calculate your age in excel, some commands are required.  Generally, it is not easy to calculate through excel.  But with the help of below commands it is too much easy.   Before knowing complete formula for calculating Age, some commands are explained as under :

• Now()           = Today date
• Today()         =  Current Date
• Datedif          =  Date Difference between two dates
• "Y"                =  Years
• "YM"            =  Balance numbers of Months after completing Years
• "MD"            =  Balance numbers of Days after completing Months. 
• Command     =           =datedif(lowerdate,highestdate, "intervel")

  

You can also enter your date of birth in age calculator and check your Age.

Keep in mind that You should be Registered members of this blog before it's downloading.

Download Age Calculator (Click Here) only for Registered members

Read more: Age Calculator or How to Know Your Age in Excel ~ Tds Tax India http://www.tdstaxindia.com/2011/01/how-to-know-your-age-in-excel.html#ixzz1VA8ojPLV
Under Creative Commons License: Attribution