How to Calculate Age from Date of Birth in MS Excel (Year, Month, Day)

How to Calculate Age from Date of Birth in MS Excel (Year, Month, Day)|
Excelमें जन्म तिथि से आयु की गणना कैसे करें
Formula: =DATEDIF(B4,C4,"y")&"years"&","&DATEDIF(B4,C4,"ym")&"months"&","&DATEDIF(B4,C4,"md")&"days"
How to Calculate Age from Date of Birth in MS Excel,how to calculate age in MS Excel,calculate age from date of birth,calculate year month day from date of birth,how to do age by date of birth,calculate age upto today from date of birth,formula from calculate the age,DATE OF BIRTH CALCULATE EXCEL,calculate age in excel,excel age calculation formula,how to calculate age in excel,how to calculate age with an excel formula,age calculation in excel,excel tutorial

Пікірлер: 24

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

    Thanks for sharing your knowledge.. Useful and nice presentation

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

    Informative video keep sharing

  • @June_Sep
    @June_Sep3 ай бұрын

    thank you sir it was helpfull

  • @UNTechworld

    @UNTechworld

    3 ай бұрын

    You are most welcome Ma'am

  • @anmolaccademy6859
    @anmolaccademy68598 ай бұрын

    Thanks for the nice explanation.

  • @UNTechworld

    @UNTechworld

    8 ай бұрын

    You are always welcome 🙏

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

    Useful information..

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

    Useful content

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

    thank u

  • @UNTechworld

    @UNTechworld

    Ай бұрын

    welcome

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

    Thanks for the nice explanation. While calculating length of service,the result shows one day less.Please explain how to overcome it.

  • @UNTechworld

    @UNTechworld

    Жыл бұрын

    Sir., Thanks for your valuable comments. Let me Check and solve your problem.

  • @UNTechworld

    @UNTechworld

    Жыл бұрын

    kzread.info/dash/bejne/i2h8ldSgnJvgmdY.html

  • @ManeeshKumar-sd9zq
    @ManeeshKumar-sd9zq10 ай бұрын

    Good sir

  • @UNTechworld

    @UNTechworld

    10 ай бұрын

    Thanks and welcome

  • @rahulpawar4887
    @rahulpawar488710 ай бұрын

    How to calculate exact age day year month without using DATEDIDF

  • @ajithkumar-fb9cc
    @ajithkumar-fb9cc29 күн бұрын

    Up to months it is working after MD is not working..the days is not xoming😢

  • @UNTechworld

    @UNTechworld

    29 күн бұрын

    bro it's working. plz try again

  • @ankurdhiman1151
    @ankurdhiman11512 ай бұрын

    Sir aapne YM and MD kyooon likha jaise first time mein aapne only Y likha usi tarah kya sirf M ya D daalkar answer nahin aaa sakta tha ?? Please reply am waiting !!

  • @UNTechworld

    @UNTechworld

    2 ай бұрын

    nahi aayega.... kiyunki year identified keliye Y lika.. the above year ka month Lena isliye ym and date keliye Jo month Tha ush month ka date Lena Hai ishliye MD 👍

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

    Number of days one day less calculated sir

  • @UNTechworld

    @UNTechworld

    Жыл бұрын

    Ma'am .. rechecked and shows correct and cross verified dates manually and online. Both are same.

  • @mocktailfiction9359
    @mocktailfiction93595 ай бұрын

    Datedif not working

  • @UNTechworld

    @UNTechworld

    5 ай бұрын

    Bro..it's working. Try again

Келесі