=DATE(YEAR(A1)-1,MONTH(A1)+7,0)+MIN(DAY(A1),INDEX({31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31},MONTH(A1)+7))
Dont you just when you for twenty minutes and someone's already posted a better solution?!
Actually the problem is only with July-to-February because when you go back five months from all the other 31-day months, you end up at another 31-day month,