Comparing dates
 

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?

Comparing dates
 

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...

DataFilterAutoFilter
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