Hi

You critera range is four cells now and can be in any column you want
above your data range

Install EasyFilter if you want it easy
http://www.rondebruin.nl/easyfilter.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"rm" wrote in message ...
Thanks Ron,

It doesn't seem to work so I am a little confused. All the dates in the
spreadsheet are in column A so presumable date criteria needs also to be in
column A in the criteria range. Can you give an example of a suitable formula
or format for the criteria?



--
Thankyou RM


"Ron de Bruin" wrote:

Hi

One row

For Example in A1 and B1 the Column Name and in
A2 and B2 the criteria and the dates.

Use the US date format


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"rm" wrote in message ...
Can someone pleased help. I wish to used the advanced filter to filter
results between 2 seperate dates in a worksheet. For example I wish to
display all rows where the date lies between 01/01/2008 and 31/03/2008. What
is the format for the filter criteria and should the criteria be on one row
or 2? Any assistance is greatly appreciated.
--
Thankyou RM