Simple question - accounting for leap years in formulas calculating dates

Hi,

I have a simple formula that is calculating a date & the formula is using the number 365 to represent a year. I don't think the correct date will be calculated using this formula when a leap year is involved. How do I modify this simple formula to account for leap years and still calculate the correct dates? Please see attached file.

Thanks for your help

Try

=IF($B2=1029,EDATE($A2,-12*1),IF($B2=1030,EDATE($A2,-12*2),IF($B2=1031,EDATE($A2,-12*5))))

Try

=IF($B4=1029,DATE(YEAR($A4)-1,MONTH(A4),DAY(A4)),IF($B4=1030,DATE(YEAR($A4)-2,MONTH(A4),DAY(A4)),IF($B4=1031,DATE(YEAR($A4)-5,MONTH(A4),DAY(A4)))))

If the anniversary is on the SAME month & day.

Thanks! Much appreciated!