The formula for the date plus six months is
=EOMONTH(A1,5)

For date plus one year
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

For date plus 5 years
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))