how to find the first date?

[alivenwell]

Have a little problem. Have a complex sheet, with columns of dates.
Would like to locate the very first date column, however the dates are never the same and they are not ever in the same place on the sheet, other columns might be added. Is there a way to like. ......cells.find(date in format dd-mm-yy)?

[Bob Phillips]

There is a problem in that dates are just numbers with a special presentation style.

You could go through each cell and check that it is a valid date, but that may take some time, depending on whether you have to check every value in a column, or say just the first row.

More detail required.