Payment of Invoices in comparison with the payment period
 

Hello!

I want to know how can i create a file in excel in order to have during a
month and in different periods of time in that month the totals by supplier
that i have to pay at that time and concerning the period of payment for each
supplier. That is having a general table where i can put for example day 1,
15, 20, 31, and for each supplier have a total that is connected by formulas
that depends on the period of payment(30, 45 or 60 days)for each supplier,
and appears on each month of the year when that specific total is going to be
paid...

Please give me an answer for this question: I have mail:


Thanks!!!