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,

=YEARFRAC(A1,TODAY())


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"