Thanks for the solutions and explanations, both do exactly what I need
--
Thanks again,
MarkN


"Roger Govier" wrote:

Hi Mark

Then use
=DATEDIF(E10,NOW(),"y") & " years, " &DATEDIF(E10,NOW(),"ym")+1 & "
months "

Obviously, as you are rounding up it will be overstating by a complete
month on 12 days of the year and will give the answer of 5 years 12
months for example, once someone passes the 11th month.

You could use some form of conditional test to the addition of the 1 if
required.

--
Regards

Roger Govier


"MarkN" wrote in message
...
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