Formulas to arrange payment per dates

Hi,

I am working on one excel work sheet were i need please help on..i have created dummy template attached here.

It has four sheets of calculation..

1. Delivery
2, cost of delivery
3. Payment date
4. Payment arrange per week

Up to sheet 3 i am fine, but i am struggling to make sheet 4, here i want to arrange payment from sheet 3 to particular week but unable to figure out any formula or any method to do that.

can anyone please help..?

thanks

Nadim

cross posted without links:
https://www.excelforum.com/excel-fo...91-formulas-to-arrange-payment-per-dates.html
nadimtukin, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184