below formulae
=TODAY()-(LEFT(C1,2)*365.25)-((MID(C1,7+FIND("",MID(C1,7,99)),2))*365.25/12)

gives an output is mm/dd/yy on entering 0 years x months

but if I enter 0 years 10 months or 11 months it gives me wrong date e.g if
entered 0 years 10 months it gives 31 april 2006

plz advise
thanks