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?