Thread
:
Find Date in different format
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett