Register now or log in to join your professional community.
Yes i also agree with the answers of Miss. Ghada Eweda and Mr. Bilal Ahmed keep it up all the users.
=INT(YEARFRAC(birthdate,TODAY()))
If you need to calculate a person's age from their birth date, you can do so with the YEARFRAC, INT, and TODAY functions. In the generic version of the formula above, birthdate is the person's birthday with year, and TODAY supplies the date on which to calculate age. Because this formula uses the TODAY function, it will continue to calculate the correct age in the future as well.
In the example, the active cell contains this formula:
=INT(YEARFRAC(D4,TODAY()))
I am leaving this question for the experts to show their talent.
=(current date -date of birth) / 365.25
thanks for the invitation and sorry that i have no expertise in Microsoft excel.
Thanks for the invite ............................ Leave an answer to the experts
Agree with expert ansewrs above
I leave the answer to experts and specialists in this area .
thanks for the invitation and also agree all the answers provided by experts
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.
