How to calculate age from date of birth in excel 2007 or 2010?




About this tutorial:

Video duration: 1:22
Formula to Calculate Present Age Using Excel
.
=INT((TODAY()-DOB)/365.25)

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

4 thoughts on “How to calculate age from date of birth in excel 2007 or 2010?

    khaled abd elrahman

    (September 14, 2018 - 9:10 pm)

    goooooooooood

    Arup Chakraborty

    (September 14, 2018 - 9:10 pm)

    Use this instead
    =DATEDIF(A13,TODAY(),"Y") & " Years, " & DATEDIF(A13,TODAY(),"YM") & " Months, " & DATEDIF(A13,TODAY(),"MD") & " Days"

    Hina Panchal

    (September 14, 2018 - 9:10 pm)

    What if Today is some other day and I need number of days instead years?
    Thanks Krishna531

    Pat Hughes

    (September 14, 2018 - 9:10 pm)

    How do you calculate person's age on their birthday in 2012?

Leave a Reply

Your email address will not be published. Required fields are marked *