this will calculate average of all amounts (in B2:B200) for dates (in
A2:A200) between 1st and 12th Jan inclusive

=AVERAGE(IF((A2:A200=--"2007-01-01")*(A2:A200<=--"2007-01-12"),B2:B200)

This is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pwrichcreek" wrote in message
...
I have a spreadsheet that lists checks and deposits in chronological
sequence
and keeps a running balance of the account. Is there a function to
calculate
the average daily balance for a selected range of dates?