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)
Sir,
While the 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 at sriram15071970@gmail.com for any further clarifications.
Regards,
JSR
From India, Hyderabad
Acknowledge(0)Amend(0)
While the 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 at sriram15071970@gmail.com for any further clarifications.
Regards,
JSR
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear friends,
Can anyone tell me what is the basis of authenticity of leave rules? Is it on a calendar year or a financial year? Some claim that there is no authentic rule to maintain leave rules on a calendar year basis. Which is the correct one?
Thank you.
From India, Bangalore
Acknowledge(0)Amend(0)
Can anyone tell me what is the basis of authenticity of leave rules? Is it on a calendar year or a financial year? Some claim that there is no authentic rule to maintain leave rules on a calendar year basis. Which is the correct one?
Thank you.
From India, Bangalore
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
LEAVE RULES.doc