| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering dates
Excel 2000
I have a list of various dates from various years. Type 7/3/2000 the cell shows "July 3, 2000" Again I have various years involved... I can't figure out how to filter or autofilter so that I get a list of dates that fall in the month of July. Regardless of the year I want July of 2005 and July of 1990. Can anyone help!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering dates
I'd use another column of cells with formulas like:
=text(a2,"mmmm") And filter by that. KJ wrote: Excel 2000 I have a list of various dates from various years. Type 7/3/2000 the cell shows "July 3, 2000" Again I have various years involved... I can't figure out how to filter or autofilter so that I get a list of dates that fall in the month of July. Regardless of the year I want July of 2005 and July of 1990. Can anyone help!! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering dates
example:
A B 1 07/03/2000 2 17/07/2001 3 20/07/1990 put the formula: =month(A1) in the cell B1 and copy drag the formula in column B to where ever your data is then sort your data based on column B so then you can find all july data together. Thanks & Happy New Year, Farhad -- Farhad Hodjat "KJ" wrote: Excel 2000 I have a list of various dates from various years. Type 7/3/2000 the cell shows "July 3, 2000" Again I have various years involved... I can't figure out how to filter or autofilter so that I get a list of dates that fall in the month of July. Regardless of the year I want July of 2005 and July of 1990. Can anyone help!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering dates
Another option is to install EasyFilter
http://www.rondebruin.nl/easyfilter.htm You can do it without the helper column then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... I'd use another column of cells with formulas like: =text(a2,"mmmm") And filter by that. KJ wrote: Excel 2000 I have a list of various dates from various years. Type 7/3/2000 the cell shows "July 3, 2000" Again I have various years involved... I can't figure out how to filter or autofilter so that I get a list of dates that fall in the month of July. Regardless of the year I want July of 2005 and July of 1990. Can anyone help!! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pre-1900 dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
| filtering dates | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Linear Mode
