Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filtering dates
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. |
#2
|
|||
|
|||
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. "mindy" wrote in message ... 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. |
#3
|
|||
|
|||
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 F5SpecialCurrent regionOK 3) Press Alt ; to select all visible data or use F5SpecialVisible cells onlyOK 4) Ctrl c or EditCopy 5) InsertWorksheet 6) Ctrl v or EditPaste -- Regards Ron de Bruin http://www.rondebruin.nl "mindy" wrote in message ... 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. |
#4
|
|||
|
|||
one way
DataAuto FilterCustomselection 1 greater than or equal toandless than or equal to. HTH "mindy" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Filtering dates using a formula | Excel Worksheet Functions | |||
filtering dates | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Filtering with dates | Excel Discussion (Misc queries) |