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.
Bookmarks