Filling in charting dates with start date and # of months

So I have a list of contracts with start dates and a length (in 4 week cycles), we bill on a 4 week basis, always starting on a monday. If a contract goes for 13 cycles (annual) I need 13 billing dates, 4 weeks apart.

I'd like to be able to just fill in Column B and Column P. I think i'll probably change Column P to a drop down list of 1-13 so it doesn't accidentally break.

I hope my attachment works. First post here. What I've attached is what I'd like the resulting output to appear as.

Sure, because client B's contract goes for 2 cycles (8 weeks) and Client D's contract goes for 6

I mocked up this document before deciding to post here, I should have trimmed it down to the basics. But basically, every contract will have a start date (Column B) and a contract length (Column P). I need columns C through N to auto fill.

Thank you

It is not clear what is required. Pl try
In C2, then drag across

Please Login or Register  to view this content.