Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par danish shafiq , Accountant , Anayat Fan
Date de publication: 2016/06/11
danish shafiq
par 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
par Bilal Ahmad , DB admin and Sales Supervisor , Al-Ajwa First Est. Import & Sales of Household

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

Ghada Eweda
par 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
par 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
par 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
par ghazi Almahadeen , Project Facilitator , Jordan River Foundation

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

Ahmed Mohamed Ayesh Sarkhi
par 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