In my spreadsheet, the cells in COL F contain data with FORMAT CELLS:
Category = Date and TYPE = *3/14/2001

For example:

11/9/1998
4/28/1999
11/30/1999
4/28/2000
11/14/2003
9/6/2007
5/16/2011
6/1/2011

I need to extract the rows whose cell contents are older than a
certain date (for example: 11/14/2006 or 08/31/2011.

How can I do that?

gcotterl used his keyboard to write :
> In my spreadsheet, the cells in COL F contain data with FORMAT CELLS:
> Category = Date and TYPE = *3/14/2001
>
> For example:
>
> 11/9/1998
> 4/28/1999
> 11/30/1999
> 4/28/2000
> 11/14/2003
> 9/6/2007
> 5/16/2011
> 6/1/2011
>
> I need to extract the rows whose cell contents are older than a
> certain date (for example: 11/14/2006 or 08/31/2011.
>
> How can I do that?

Try...

Data>Filter>AutoFilter
Choose Custom from the dropdown and specify your criteria.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc