Checking a cell for a value then adding months/years to a date in a second column

I am trying to create an IF statement that will check column a2 for a value (y or n). If the value is y, then I need to add 75 months (6 years and 3 months) to the date in column b2. If the value is n, then I need to only add 36 months to the date in column b2. The new date will be stored in column c2 in either instance. Attached is an example of what I have so far.

The IF statement that I came up with is:

IF(a2="y", c2.value=Date(Year(b2),Month(B2)+75,Day(b2)), [c2.value=Date(Year(b2),Month(b2)+36,Day(b2)])

This formula will be applied to a spreadsheet with a lot of entries. I was planning on just copying the formula, but a looped IF statement may work better. I am not sure.

Thanks in advance for the help.

Arli

Date_IF_Statement.xlsx

=IF(A2="y", DATE(YEAR(B2),MONTH(B2)+75,DAY(B2)),DATE(YEAR(B2),MONTH(B2)+36,DAY(B2)))

Not really ninja-ed by above poster, but I certainly hadn't seen that reply when I posted, doh!

They both work great! Thanks for your time.

Arli