Excel Advanced filter - Filtering using dates

R

rm

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.
 
R

Ron de Bruin

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
 
R

rm

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?
 
X

xlmate

try using Custom Filter,

1. Choose Filter under Data on the menu bar
2. Click on the filter arrow
3. Choose Custom
4. click on the first drop down and select is greater than or equal to
5. click on the drop down beside the first and choose your date
6. tick And
7. click on the 3rd drop down below the first and select is less than or
equal to
8. click on the drop down beside the 3rd and choose the date
9. click OK

this will give the range of data between the dates you have specified.

HTH
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis









rm said:
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?
 
R

Ron de Bruin

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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top