Hi Megan,
I guess I am a little confused. What is the Dr? Reduced
A/P and I assume the Cr is cash? You have a list of
recurring invoices that are paid on the same day each
month, I think and then some invoices that are not
recurring, but are paid on specific dates? I this what is
happening? Not sure, but it appears that a "yes" must be
present for an invoice to be paid, if this is so, is it
so for recurring invoices too? Then you have other
sheets, which are each of of the week, ie Monday. Maybe a
sheet for every day of the month or maybe this is 5
sheets, for each weekday ie Mon - Fri? You want totals on
each of the 5 sheets of all payments made, divided by
week. Is this what you are looking for?

Thanks,
David
-----Original Message-----
Hi,
I am working a spreadsheet that contains banking
information. There are several sheets, one is recurring
bills and another is debits. What I would like to do is
have the debit sheet reflect what recurring bill has
been
paid on each date. For example, bill ABC has been noted
as
paid on Monday 4/5 at a value of $20.00(by
selecting "yes"
in column B, column C's value is "Monday" (using the
TEXT(WEEKDAY(a1),"dddd" function). In worksheet debit, I
would like column Monday to reflect the amount of
$20.00.
In addition, all recurring bills and debits are
seperated
into weeks (wk 1, wk 2, etc), so not only do I need to
reflect what has been paid on Monday, but also what has
been paid on Monday in week one.
Another note, how would I forward a value to the next
cell, say if 2 payments were made on Monday, week one?

Thank you in advance,
Megan
.