Calculation Of Age From Date Of Birth In Excel - RAR Download

Hi all, Greetings of the day!! Can anyone help me how to calculate age from the given date of birth in excel sheet. I find it difficult to calculate manually when there is thousands of data.
31st October 2013 From Kuwait, Kuwait

Dear Muhamir, Its very simple. Today- date of birth. you will get the exact age of employees. Find the attachment. it may be useful to you. .
31st October 2013 From India, Bangalore

Attached Files (Download Requires Membership)

Age.rar (11.6 KB, 420 views)

Sir, While file enclosed by Roopanagaraju is one way of calculating the age, you can also try the following:
AGE
YEARS:=DATEDIF(B3,TODAY(),\"y\") wherein in Cell B3 you may enter the date of birth
Months:=DATEDIF(B3,TODAY(),\"ym\") wherein in Cell B3 you may enter the date of birth
Days:=DATEDIF(B3,TODAY(),\"md\") wherein in Cell B3 you may enter the date of birth
The above mentioned formulas will give you the exact number of years, months, days lived till date. You may write back to me on sriram15071970@gmail.com for any further clarifications
Regards
JSR
31st October 2013 From India, Hyderabad

Dear friends,
Can anyone tell me what is the basis of authenticity of leave rules. Is it on calendar year or financial year ?? Some claim that there is no authentic rule to maintain leave rules on calendar year basis ... Which is the correct one ??
31st October 2013 From India, Bangalore