Calculating age

N

Neil Chamberland

I need to find a formula that will calculate an age in
years and months. When i use a regular formula I get an
answer (eg 40.8) but this is 40 years and 8/10 months,
what I need is years and months exactly.
 
A

Arvi Laanemets

Hi

=DATEDIF(A1,TODAY(),"Y") & " years " & DATEDIF(A1,TODAY(),"YM") & " months"
 
Top