MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculate Age in Excel 2000

Posted by Ricky Cunningham on January 27, 2002 10:22 AM

I'm sure someone's had this problem before - how do I calculate someone's age in years and months from their Date of Birth and Today's date? Thanx

Posted by Aladin Akyurek on January 27, 2002 10:28 AM

=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months

or, more usable,


Posted by AL on January 27, 2002 6:28 PM

If you want to get to days use this

="Age is "&DATEDIF(A1,TODAY(),"y")&" Years, "&DATEDIF(A1,TODAY(),"ym")&" Months and "&DATEDIF(A1,TODAY(),"md")&" Days"