Reports on the plan of consolidated payments in EXCEL
 

I do have several orders from suppliers. Each order has its own plan of
payments - one may have three pertial payments in three monthes, the other -
five and so on. Against each partial payment I put the date when it's due to
be paid.

The question is: how do I make in EXCEL the consolidated report which shows
what total amount should be paid weekly?