Filter

  • Thread starter Thread starter gilbert
  • Start date Start date
G

gilbert

Hi..

Need help here...

Supposing all my dates is in figure type...eg. 2/2/2004, 4/2/2004
5/2/2004, 4/3/2004, 5/3/2004. 1/4/2004....

how do I use filter to show all dates in the month of February?

Please help...I am sure it can be done, right
 
Hi
one way:
- select 'Data - Filter - Autofilter'
- select 'Custom' in the appearing listbox
- choose two conditions (AND):
a) >=1/2/04
b) <=2/29/04

This will filter all dates for February 2004

Frank
 
Unless i'm missing something the way to do it is to use a
custom filter.

You can get to the filter by cliking data (make sure the
cell with your heading is selected), filter, auto filter.
Then from the list select custom filter.

The first criteria is greater than or equal to 1/2/04 and
the second criteria as less than or equal to 28/2/04.

Should work
 
Sure is
When you click on the dropdown arrow, select custom
Choose "Greater than or equal to from the 1st dropdown and enter 1/2/2004
Choose AND from the option buttons
Choose Less than or equal to from the 2nd dropdown box and enter 29/2/2004

HTH
Geoff
 
To make it easy to filter for a date range, you can type the dates on
the worksheet, and add a new column to your table:

--Type the start date in a cell (J1 in this example)
--Type the end date in a cell (L1 in this example)

--Add a column to the table, with a heading, e.g. DateRange
--In the first data row, type a formula to check the date.
For example, if the date is in column A:
=AND(A2>=$J$1,A2<=$L$1)
--Select a cell in the table, and choose Data>Filtr>AutoFilter
--From the dropdown heading in the DateRange column, choose TRUE
 
Back
Top