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
Acknowledge(0)
Amend(0)
From Kuwait, Kuwait
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
24From India, Bangalore
Acknowledge(0)Amend(0)
While the file enclosed by Roopanagaraju is one way of calculating age, you can also try the following:
AGE Calculation in Excel
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, and days lived to date. You may write back to me at [Email Removed For Privacy Reasons] for any further clarifications.
Regards,
JSR
From India, Hyderabad
Acknowledge(0)Amend(0)
AGE Calculation in Excel
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, and days lived to date. You may write back to me at [Email Removed For Privacy Reasons] for any further clarifications.
Regards,
JSR
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
LEAVE RULES.doc