First, we need to determine what the daily balance is each day. Assuming
starting balance is in F1, with dates in a2:a10, credits in b2:b10, and
debits in c2:c10

Create a list of in e2 downward
formula in F2 is:
=F1+SUMIF(A$2:A$10,E2,B$2:B$10)-SUMIF(A$2:A$10,E2,C$2:C$10)
Copy down as needed.

Running average balance then, in G2:
=AVERAGE(F$1:F2)
Copy down as needed

--
Best Regards,

Luke M
"Brian" wrote in message
...
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?