Originally posted by kato2274
piece of cake

a1 4/2/03
b1 =DATE(YEAR(a1),MONTH(a1)+11,DAY(a1))
c1 =DATE(YEAR(a1),MONTH(a1)+12,DAY(a1))

edit
didn't it occur to anyone to open up excel help and type "add months"????
Yup, I pasted the help file as a hint...