Formula Help Please Projecting Member Renewal Dates Based On 6,7,12 & 13 Months?

I have a member's only site that I run. A membership is purchased for either 6, 7, 12 or 13 months. I have just exported all the recurring payment list from Paypal. It has member's contact data and the last column is their original signup date in this format 10/6/2010.
Can you help me please figure out a formula based off the original signup date in one cell. The next cell to the right would be the number of months multiplier. Each cell to the right would be a projected renewal date in the above date format. Can that formula be setup so it loads cells to its right projecting every renewal period date over the next ten years? An easy example would be below. Where it gets really screwy for me is 7 & 13 months starting on a numbered day that isn't in every month like the 29th. I have a spread sheet of three hundred members so I would need to copy this formula for at least 300 members (down a column?).

Original Date - Membership Period - Renewal Date - Renewal Date - Renewal Date - Etc...
10/6/10 - 7 - 5/6/11 - 12/6/11 - 7/6/12

Thank you very much for the help. I sincerely appreciate it.

Regards,

Terry

Hi TMS,
Here the sample workbook attached. How do I edit your formula to make this work starting at column "G"?

Regards,

Terry

Hi Trevor,
I tried this in column "I" with 8/21/2014 in G2 and 12 (months) in H2 and the result in I2 was 8/21/2021.

Please Login or Register  to view this content.

Regards,

Terry

This works really great! Thank you very much.

Would it be really involved to ask if there is a way to also do conditional formatting with this formula (based on todays date or the date the workbook is opened again) so every day result that is in the past is dark red and every day result that is in the future is dark green?

Is that even possible? Formula creation to actually do what I want is way over my head.

I sincerely appreciate the help.

Regards,

Terry