TheExcelAddict.com
Microsoft Excel "Quick Tips"

Calculate A Person's Age

Here is an easy way to calculate someone’s age using Excel. In cell A1 enter someones date of birth and in another cell enter this formula (copy and paste it right from this page).

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"

This will return a string like: 33 years, 9 months, 18 days

You could also use this technique in many other situations where you need to calculate the time between today and some any other date.