Hi folks, am doing web queries pulling down data. In column A, the date and time show up - Oct 4, 2007, 5:00 pm.


In any worksheet, there could be between 1 and 50 rows with data. The most recent date & time show up in cell A5 in each worksheet. I'd like to find the oldest date for each worksheet.

Thanks to another soul here from a prior inquiry, he said that I needed to convert the date, so in column J on each worksheet, I have the following formula for each row. =DATEVALUE(LEFT(A5,FIND(",",A5,FIND(",",A5,1)+1)-1))+TIMEVALUE(MID(A5,FIND(",",A5,FIND(",",A5,1)+1) +2,255)) .

I'd like to find the oldest date in either column A or Column J which could be in any row between row 5 or row 55.

Any help is appreciated.

Regards,

Bob