Calculate age - show months as well

[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

 

[fredg]

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

See:
http://www.accessmvp.com/djsteele/Diff2Dates.html