Calculate age - show months as well

  • Thread starter Thread starter KAquestions
  • Start date Start date
K

KAquestions

Hi all,

I currently have the following formula to calculate age:

=DateDiff("yyyy",[DateofBirth],Now())+Int(Format(Now(),"ddmm")<Format([DateofBirth],"ddmm"))

I'd also like to show their age in months as well, eg. 2 years 3 months

Can you please help?

Thanks,

Kirstie
 
Back
Top