Modifying dates?

[redlion3]

I have a long list of anniversary dates and basically I need to calc an increase on any of those after 7/31/2007 and before 12/31/2007.
Anyone know an easy way to do this?

This is what the detail looks like. I know how to create a formula that says if cell (anniversary date) is greater than 7/31, then increase 3% - but what is messing me up is the fact that there are the 2 years - 2007 & 2008. Id appreciate ANY help. Thanks!

Rates Anniversary Date
16.86 04/30/08
11.33 07/24/07
12.73 07/09/08
10.00 06/21/08
18.57 09/04/07

[Paul]

Hi redlion,

Try this formula:

=IF(AND(B1>DATE(2007,7,31),B1<=DATE(2007,12,31)),A1*1.03,A1)

This assumes your rates are in A1 downward, and dates in B1 downward. Adjust your ranges to suit.

[redlion3]

This is EXACTLY what I was looking for. Thank you