Lookup between dates

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

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
 
Assume your start date is in row 1, your end date is in row 2, row 3
contains your headings, and your data starts in row 4. Column A is the date,
column B is the amount, column C is Current, D is Month 1, etc. Use this
formula in C4:

=if(and($a4>=c$1,$a4<=c$2),$b4,"")

Copy down and across.

Regards,
Fred.
 
Back
Top