Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup between dates
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup between dates
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. "Amanda" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to retrieve dates from lookup | Excel Discussion (Misc queries) | |||
lookup/vlookup for dates, please help! | Excel Worksheet Functions | |||
Advanced Lookup w/Dates | Excel Worksheet Functions | |||
How to lookup the dates of a list that are only the first of the . | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions |