hi,

I have a debtor list and I want to create an aging for it. How do I write a
formula that looks at a long list of debtors and allocates it into a month?

THe information I have is in a long list format, i.e.

01/01/00 £250.00 Mrs Smith Water bill
01/02/00 £500.00 Mr Smith Electricity bill
etc


Example:
Today is 01/03/00
01/03/00 01/02/00 01/01/00
-31/03/00 29/02/00 31/01/00
Current Month 1 Month 2
01/01/00 £250 £250
01/02/00 £500 £500
01/03/00 £700 £700

Thank you

Amanda