View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Excel Advanced filter - Filtering using dates

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