Find Date in different format

[Alex]

Hello,

My column A contain dates from Jan 20 2009 till Jan 25 2009. Depending on
the computer (Windows settings / Excel settings), dates will be formated
differrenly: 2009-01-20 or 1/20/2009 or........ Date from the database comes
in 2009-01-20 format. I need to find date from the database in the column A.
Can I use Application.FindFormat for that? NumberFormat?
Another question, how I can retrieve this date settings from Excel? (I can
convert database's date format to Excel's).

Thank you very much.

 

[Don Guillett]

try using application.MATCH(yourdatefromacell,a:a,0)