Hello,

I am looking for a formula that will calculate how old a person is in years
and months, with months being rounded up to the nearest complete month. If
somebody was born yesterday, I would like the formula to return "0 years, 1
month".

I was 'experimenting' with:

=DATEDIF(E10,NOW(),"y") & " years, " & ROUNDUP(DATEDIF(E10,NOW(),"ym"),0) &
" months"

and while this is close, it's not right.
--
Any assistance appreciated,
MarkN