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.
From Kuwait, Kuwait
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. .
From India, Bangalore
24From India, Bangalore
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
From India, Hyderabad
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
From India, Hyderabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Age & Character Calculation.zip
Age & Character Calculation.xls