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