All,

I have a large spreadsheet of data with several columns one of which contains dates.

Is there a way I can add a start date in A1 and a finish date in B1 and then filter out the data to only show lines which fall between between and including those two dates.

I have tried using advanced filters but this only seems to work for single dates or by having to type all the dates in the range (a bit unuser friendly) I'm sure there a way but I can't figure it out.

Sadly the date ranges I would like to use are quite obscure i.e 15/07/2005 - 08/08/2005, so I cant just filter by month using a helper column.

Thanks any pointers appreciated.
AU