Comparing dates

[gcotterl]

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?

 

[GS]

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.