Age Today formula

  • I have been searching for formulas to write the age today of my list of people. The problem that I had is regarding the value that pops out... It is always #VALUE . As far as I can remember, I followed the formula and the formatting of the cell. Help please? Thank you so much! :)

  • Carim

    Changed the title of the thread from “#VALUE result whenever I use the Age Today formula” to “Age Today formula”.
  • Hi,

    For Future Readers ... the Age Formula expressed in Years, Months and Days :

    =DATEDIF(A1,TODAY(),"y")&" y "&DATEDIF(A1,TODAY(),"ym")&" m "&DATEDIF(A1,TODAY(),"md")&" d "

    Hope this will help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!