filtering dates

M

mindy

I was looking for a way to filter dates in a database to extract a range of
data between one date and another date. What's the best way to do this? I
seem to be having problems with my advanced filter.
 
A

Alan

You coud use Custom on AutoFilter, use 'is less than or equal to' the end
date, use the operator 'And', then 'is greater than or equal to' the start
date.
Regards,
Alan.
 
R

Ron de Bruin

Hi mindy

EasyFilter can do this for you if you want
http://www.rondebruin.nl/easyfilter.htm

Another way is to Use AutoFilter (use Custom : greater than and less than)

Then Copy the filter result

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Press Alt ; to select all visible data or use F5>Special>Visible cells only>OK
4) Ctrl c or Edit>Copy
5) Insert>Worksheet
6) Ctrl v or Edit>Paste
 
R

Ray A

one way
Data>Auto Filter>Custom>selection 1 greater than or equal to>and>less than
or equal to.
HTH
 
Top