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...
______________________________________
KZread Channel Growth Accelerator:
vimeo.com/ondemand/youtubeacc...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections

Пікірлер: 20

  • @J.i.M.9604
    @J.i.M.9604 Жыл бұрын

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

  • @dddd-uk4vn
    @dddd-uk4vn Жыл бұрын

    man is completing all the side missions

  • @will78787

    @will78787

    Жыл бұрын

    With the max score too!

  • @doctordyl3105

    @doctordyl3105

    Жыл бұрын

    🤣🤣100% completion… OCT the 🐐🐐🐐

  • @Do-Some-Change

    @Do-Some-Change

    Жыл бұрын

    That we call *PRO GAMER*

  • @anycolouryoulike8567
    @anycolouryoulike8567 Жыл бұрын

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

  • @Ulibert
    @UlibertАй бұрын

    it doesnt work for me it says #value error

  • @dagochevez717
    @dagochevez717 Жыл бұрын

    This is an interesting video to make

  • @Tina-ho7jx
    @Tina-ho7jx Жыл бұрын

    You literally teaching me everything😭

  • @ritajabal
    @ritajabal Жыл бұрын

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

  • @hannahrepollo

    @hannahrepollo

    Жыл бұрын

    not the husband LMAO

  • @ritajabal

    @ritajabal

    Жыл бұрын

    @@hannahrepollo PLEASE

  • @hannahrepollo

    @hannahrepollo

    Жыл бұрын

    @@ritajabal FACTS THO 😍

  • @jomangeee9180
    @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

  • @greglapura2495
    @greglapura24954 ай бұрын

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

  • @CorporateZombi
    @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
    @rommelabejero38411 ай бұрын

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

  • @danishsinharoy9991
    @danishsinharoy99915 ай бұрын

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

  • @Avion_Animz
    @Avion_Animz Жыл бұрын

    Hello

  • @jjsmallpiece9234
    @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