OK, I need to use an IF statement to add a certain amount of time to a date.
Example..
Date cell is K4
IF hurdle is L4
formula is in M4

The way it needs to work is, if L4 = "Yes" then I need to add 7 years and 9 months to the date in K4. If not, I need it to add 9 years and 9 months to the date in K4.

Everything I try comes out with a "#VALUE!" error in the cell.
Here is one of the ways I tried it...
=IF(L4="Yes",K4+2465,K4+3560)

Note, K4 and M4 are both formatted as dates in the same configuration.
Any help would be awesome.