I have 2000 row shreadsheet of dates. Need to determine which date is
greater than 10/31/2005 and return to another worksheet.
Any guesses on least painful way to do?

You haven't said whether there is more than one date 10/31/2005, but you can
try this array formula, entered with CTRL+SHIFT+ENTER:

=MAX(IF(B2:B2001DATE(2005,10,31),B2:B2001))

If there is more than one such date, the above returns the latest one. If you
want the first one in the list,

=INDEX(B2:B2001,MIN(IF(B2:B2001DATE(2005,10,31),R OW(B2:B2001)-1)))


On Fri, 23 Sep 2005 11:59:02 -0700, cindyd
wrote:

I have 2000 row shreadsheet of dates. Need to determine which date is
greater than 10/31/2005 and return to another worksheet.
Any guesses on least painful way to do?

Thank you for your reply! Yes there are many dates in that column.
From 2003 to 2014.
I want only the dates greater than 10/31/2005 to return to the other
worksheet. ONLY if they meet the criteria of 10/31/2005.

"cindyd" wrote:

I have 2000 row shreadsheet of dates. Need to determine which date is
greater than 10/31/2005 and return to another worksheet.
Any guesses on least painful way to do?

I'de engage an Auto-filter on your total range;
then on the date column select the "greater than" - also
enter 10/31/2005 in box.
This should give you **ONLY** records of 10/31/05 and beynd.
Copy and Paste All these records to a new sheet.
HTH

"cindyd" wrote:

Thank you for your reply! Yes there are many dates in that column.
From 2003 to 2014.
I want only the dates greater than 10/31/2005 to return to the other
worksheet. ONLY if they meet the criteria of 10/31/2005.

"cindyd" wrote:

I have 2000 row shreadsheet of dates. Need to determine which date is
greater than 10/31/2005 and return to another worksheet.
Any guesses on least painful way to do?