Formula to Project Member\'s Renewal Date Based On 6,7,12 & 13 Months? I have a

Question

Formula to Project Member's Renewal Date 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.

Explanation / Answer

1. In cell C2, enter this formula and format the cell as Date

=EDATE($A2,$B2)

2. In cell D2, enter this formula and copy right (till L2). Format D2:L2 as Date

=EDATE(C2,$B2)

3. Select C2:L2 and press Ctrl+C

4. Select the range below and paste

Hope this helps.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.