Comparing dates

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

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?
 
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?
Click to expand...

Try...

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