Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the formula of getting age from birthday in Microsoft Excel?

user-image
Question added by danish shafiq , Accountant , Anayat Fan
Date Posted: 2016/06/11
danish shafiq
by danish shafiq , Accountant , Anayat Fan

Yes i also agree with the answers of Miss. Ghada Eweda and Mr. Bilal Ahmed keep it up all the users.

Bilal Ahmad
by Bilal Ahmad , DB admin and Sales Supervisor , Al-Ajwa First Est. Import & Sales of Household

=INT(YEARFRAC(birthdate,TODAY()))

Ghada Eweda
by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.

Getting age from birthday in Excel Excel formula: Get age from birthday =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()))

Adam Ahmed
by Adam Ahmed , IT & Web Developer , Freelance

Basm allah alrahman alrahim

 

Like Ms  Ghada Eweda , and Mr Bilal Ahmad answers

 

 

I am leaving this question for the experts to show their talent.

Mohammed Adil
by Mohammed Adil , SENIOR ACCOUNTANT , MOHAMMED & WALEED AL OMAIR FURNITURE CO

=(current date -date of birth) / 365.25

 

thanks for the invitation and sorry that i have no expertise in Microsoft excel.

ghazi Almahadeen
by ghazi Almahadeen , Project Facilitator , Jordan River Foundation

Thanks for the invite ............................ Leave an answer to the experts

Ahmed Mohamed Ayesh Sarkhi
by Ahmed Mohamed Ayesh Sarkhi , Shared Services Supervisor , Saudi Musheera Co. Ltd.

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

More Questions Like This