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

Question

danish shafiq · Answer

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

Bilal Ahmad · Answer

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

Ghada Eweda · Answer

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 · Answer

Basm allah alrahman alrahim

Like Ms Ghada Eweda , and Mr Bilal Ahmad answers

Ali Murtaza · Answer

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

Mohammed Adil · Answer

=(current date -date of birth) / 365.25

hassan mujtaba · Answer

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

ghazi Almahadeen · Answer

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

Ahmed Mohamed Ayesh Sarkhi · Answer

Agree with expert ansewrs above

dalal alharbi · Answer

I leave the answer to experts and specialists in this area .

ali hassan · Answer

thanks for the invitation and also agree all the answers provided by experts

Products By Bayt.com

Use Our Mobile App

Start networking and exchanging professional insights

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

Popular Searches

More Questions Like This