How To Calculate Age From Date of Birth In Excel

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 20

  • @J.i.M.9604
    @J.i.M.9604 2 роки тому +9

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

  • @dddd-uk4vn
    @dddd-uk4vn 2 роки тому +37

    man is completing all the side missions

    • @will78787
      @will78787 2 роки тому +2

      With the max score too!

    • @doctordyl3105
      @doctordyl3105 2 роки тому +1

      🤣🤣100% completion… OCT the 🐐🐐🐐

    • @Do-Some-Change
      @Do-Some-Change Рік тому

      That we call *PRO GAMER*

  • @anycolouryoulike8567
    @anycolouryoulike8567 2 роки тому +7

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

  • @Ulibert
    @Ulibert 7 місяців тому +1

    it doesnt work for me it says #value error

  • @Tina-ho7jx
    @Tina-ho7jx 2 роки тому

    You literally teaching me everything😭

  • @ritajabal
    @ritajabal 2 роки тому

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

  • @greglapura2495
    @greglapura2495 10 місяців тому

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

  • @rommelabejero384
    @rommelabejero384 Рік тому

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

  • @dagochevez717
    @dagochevez717 2 роки тому +2

    This is an interesting video to make

  • @jomangeee9180
    @jomangeee9180 2 роки тому +1

    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

  • @CorporateZombi
    @CorporateZombi 2 роки тому

    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?

  • @jjsmallpiece9234
    @jjsmallpiece9234 2 роки тому

    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
    @danishsinharoy9991 Рік тому

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

  • @Avion_Animz
    @Avion_Animz 2 роки тому

    Hello