Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing dates | Excel Worksheet Functions | |||
Comparing dates | Excel Worksheet Functions | |||
comparing dates | Excel Programming | |||
Comparing Dates | Excel Discussion (Misc queries) | |||
Comparing dates | Excel Programming |