Excel Advanced filter - Filtering using dates

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

 

[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

 

[JB]

Dates Data Base in B2:Bxxx

FisrtDate In F2
LastDate In G2

Criteria: D12
Formula in D2: =And(B2>=$F$2,B2<=$G$2)

http://cjoint.com/?bvrISc1MjG

JB
http://boisgontierjacques.free.fr

 

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

 

[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

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?

 

[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

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?