Add years and months to age

[KClem]

Hi

I need to add years and months to a persons age in two situations
1. Age 26 - i need to add 1 year and 6 months
2. Age 26 - i need to add 300 months

Can anyone help me please?

Thanks

[CAABYYC]

D2=IFERROR(SUBSTITUTE(LEFT(C2,FIND(" year",C2)-1)+B2&MID(C2,FIND(" year",C2),999),"ear","ears"),(B2+(LEFT(C2,FIND(" ",C2)-1)/12)&" years"))

[KClem]

Thanks for this it works perfectly. I just need to work out how to add months now.

[KClem]

i worked it out.