It seems a formula would do it, but we need to see sample data. Post it here
in text form, and try and lay it so that it is readable.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Kara" wrote in message
...
I am working with a spreadsheet that caculates tuition balances for a
small
school, about 90 entries. I have it all working just fine with regular
formulas, that is all but one. I would like to see at any given time how
delinquent the families are with their monthly tuition. Every family
usually
pays in a 10 month period, but most have different amounts that they pay
each
month. If needed I can e-mail the spreadsheet. I believe it will need to
be a
date driven formula. Right now what I do to get this amount is to take the
total tuition subtract what their monthly payments would be and come up
with
the balance. Then I compare that number to the acutal amount paid in and
the
different would be delinquent tuition (or overage for the year). Only
problem
I don't have a clue how to do it.