Hello! I need an Excel Formula that can compute the following...
I have an excel workbook that contains several sheets specific to a
different account. The format on each sheet is identical: Column A
(Deposits), C (Interest accrued for the month) & E (disbursements) contain
dates while columns B, D, & F contain the amounts for each transaction.
Column G contains the running total for each month B+D-F. I need a formula
that can disperse the amount of interest accrued from the bank for the month
between the different accounts/sheets based on each accounts average daily
balance. For example I accrued $1,146.00 of interest for the month of January
2009. I need a formula to go in column D that divides the $1,146.00 among the
different spreadsheets based on each account's average daily balance on
01/31/2009.

Thanks