Find Date in different format
 

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.

Find Date in different format
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alex" wrote in message
...
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.