Thread: Comparing dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gcotterl[_2_] gcotterl[_2_] is offline
external usenet poster
 
Posts: 83
Default 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?