No Tags Found!


Muhaimer
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
roopanagaraju@ymail.com
24

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
Attached Files (Download Requires Membership)
File Type: rar Age.rar (11.6 KB, 420 views)

Sreeram70
38

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
krsiyer
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 ??

From India, Bangalore
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.