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.