Calculating and adding dates + n

Assuming you put your initial date on G3 cell, you can use a formula like this:

=DATE(YEAR(G3),MONTH(G3)+8,DAY(G3))

to add 8 months to the initial date.

Then you can use Conditional Formatting to change the fill color, like this:

=IF(($E$3-$D$3)>7,TRUE,FALSE)  - For Red fill
=IF(AND(($E$3-$D$3)<7,($E$3-$D$3)>0),TRUE,FALSE) - For Amber fill

Please check the attached example.

jppinto
sample.xls

As desired Please see attached spreadsheet.

Hope this helps
sample.xlsx

Hi, propolis,

What should the Target Date be when the Contact Date is 31/1/2012 and the number of months is one? 29/02/2012? 02/03/2012?

Thanks,
Brian.

Thanks, propolis!

Hi, propolis

May I know the limitations you faced with the solution I proposed?

Thanks!

propolis, was there something wrong with my solution also?