Dynamic list depending on date....?

**Degeneratemoo** · 03-28-2009, 02:11 PM

Hi!

I'm planning my wedding and I have a wedding budget planner spreadsheet I've written in Excel 2007. The planner contains a list of items I need to pay for (i.e. flowers), the balance remaining for each item and a date when the balance is due for each item.

What I would like is for the spreadsheet to show a list of items where the balance is due to be paid in the next 6 months, from todays date.

I.e.

Item Balance Due date
Flowers £200 11-May-09
Chairs £300 11-Jun-09
Rings £500 23-July-09

Etc..

Is there an easy way to produce a list like this? I know how to check against dates etc, it's just the list I'm not sure how to do.

Many thanks,

DG

**NBVC** · 03-28-2009, 02:42 PM

Hi,

See attached:

Formula used in Sheet2!A2:

Please Login or Register  to view this content.

Adjust the ranges that refer to A2:A7 and C2:C7 to your actual range sizes and then confirm the formula with CTRL+SHIIFT+ENTER instead of just ENTER, the { } brackets will appear automatically. Then copy down and across as far as you need to get all possible outcomes.