How To Calculate Age From Date of Birth In Excel

This excel video tutorial explains how to calculate a person's age using his date of birth and the current date. It explains how to do this using the YearFrac function and the INT function within excel.
Excel Tutorial For Beginners: • Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
How To Calculate The Total Hours Worked:
• How To Calculate The T...
How To Make a Time-Sheet In Excel:
• How To Make a Simple T...
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
Excel - Business Account Ledger:
• Business Account Ledge...
________________________________________
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
Excel Vlookup Function:
• How To Use The VlookUp...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
Multiple Dependent Drop Down Lists:
• How To Create Multiple...
How To Show & Hide Formulas:
• How To Show and Hide F...
______________________________________
TH-cam Channel Growth Accelerator:
vimeo.com/onde...
Final Exams and Video Playlists:
www.video-tuto...
Full-Length Math & Science Videos:
/ collections

[@J.i.M.9604]

You're teaching me chemistry, physics, math, and IT. You're amazing keep up the good work.

[@dddd-uk4vn]

man is completing all the side missions

[@will78787]

With the max score too!

[@doctordyl3105]

🤣🤣100% completion… OCT the 🐐🐐🐐

[@Do-Some-Change]

That we call *PRO GAMER*

[@anycolouryoulike8567]

Hoping that one day we will get a stream of Biochemistry videos from the legend himself.

[@Ulibert]

it doesnt work for me it says #value error

[@dagochevez717]

This is an interesting video to make

[@jomangeee9180]

thank you, btw your cursor blocks the formula making it less visible, if you can make it more transparent that would be great, or maybe just use an arrow

[@Tina-ho7jx]

You literally teaching me everything😭

[@ritajabal]

excel is so confusing so this was helpful😭 thank you Husband 💘

[@hannahrepollo]

not the husband LMAO

[@ritajabal]

@@hannahrepollo PLEASE

[@hannahrepollo]

@@ritajabal FACTS THO 😍

[@greglapura2495]

but what if the other way around. the age is given and how to determine the birthdate

[@CorporateZombi]

Now, just for interest sake I want to know how often this method would be wrong. One example would be anyone who just turned one in a non-leap year. You'd be dividing by 365 by 365.25, and get less than one. This would int() to 0. When it was their birthday and they were actually 1. (Your automated birthday message could be a day late!)
Second question is, is there a simple way to always get it exactly right?

[@rommelabejero384]

sir why there is error if the year wa start at 1800?

[@jjsmallpiece9234]

Another example of how dated and lack of user friendly options in Excel. Instead of having to write a formula, why not a command where you can simply select the 2 cells with the start and end date

[@danishsinharoy9991]

My DOB1-1-1944 when I will reach 80 years of age

[@Avion_Animz]

Hello