Bayt.com

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

Computer Science Microsoft Office Computer Skills IT
user-image
تم إضافة السؤال من قبل danish shafiq , Accountant , Anayat Fan
تاريخ النشر: 2016/06/11
التصويت كمفيد (8) المشاهدات (18) المتابعون (18) الإجابات (15) بلّغ عن السؤال
أضف إجابة
أنشئ حسابًا أو سجّل الدخول للإجابة
danish shafiq
من قبل 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
من قبل Bilal Ahmad , DB admin and Sales Supervisor , Al-Ajwa First Est. Import & Sales of Household

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

Ghada Eweda
من قبل 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
من قبل Adam Ahmed , IT & Web Developer , Freelance

Basm allah alrahman alrahim

 

Like Ms  Ghada Eweda , and Mr Bilal Ahmad answers

 

 

Ali Murtaza
من قبل Ali Murtaza

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

Mohammed Adil
من قبل Mohammed Adil , SENIOR ACCOUNTANT , MOHAMMED & WALEED AL OMAIR FURNITURE CO

=(current date -date of birth) / 365.25

 

hassan mujtaba
من قبل hassan mujtaba

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

ghazi Almahadeen
من قبل ghazi Almahadeen , Project Facilitator , Jordan River Foundation

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

Ahmed Mohamed Ayesh Sarkhi
من قبل Ahmed Mohamed Ayesh Sarkhi , Shared Services Supervisor , Saudi Musheera Co. Ltd.

Agree with expert ansewrs above

 

dalal alharbi
من قبل dalal alharbi

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

ali hassan
من قبل ali hassan

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

المزيد من الإجابات
أضف إجابتك
المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟

طلب المساعدة