Hi Guys and Gals.
Attached is an excel spreadsheet showing the following
Col A - Week No
Col B - Date
Col C - Payment
Col D - Every nth Weeks
Col F - Fixed Payment
So what I'm looking for is a formula in Col C, Where I receive a fixed payment of $20 (Col F) the day following 12 Weeks (Col D) up to just before the following payment. Then The next payment run starts a day after week 24 (accumulative) and so on. Hope I explained this OK. But I have manually filled in the required numbers to show what is required.
Thanks in advance.