create dynamic balance sheet..with days of month..

I am basically taking each month and creating the number of days for it in a column. Column to the right has debits and column to right of that has credits.
I already have it set up to have a beginning running total. I also have it set up so the debit and credit part works correctly and updates amount throughout entire month.

I also have set up is an area where we have set up our bills, how much they are and a number that represents the day they come out.

How would I write the sheet so when I change the day the bill comes out it appropriately plugs in the corresponding bill amount to the corresponding day in my list of 31 dates in the debit line?
Thanks

Post a sample workbook and manually show the result you expect/want.