B
Brian
This might be a simple question...but I seem to be struggling to obtain a
formula.
I have a spreadsheet with an opening balance and then multiple rows of
activtity (either deposits or withdrawls) and sometimes there is daily
activity....sometimes we can go weeks without activity
I'm trying to establish a formula that will give me the Average Daily
Balance in the account using the rows of data factoring in the Deposit/
Withdrawl amounts and the dates.
Any suggestions?
formula.
I have a spreadsheet with an opening balance and then multiple rows of
activtity (either deposits or withdrawls) and sometimes there is daily
activity....sometimes we can go weeks without activity
I'm trying to establish a formula that will give me the Average Daily
Balance in the account using the rows of data factoring in the Deposit/
Withdrawl amounts and the dates.
Any suggestions?