| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How to find a cell with a particular date format? | Excel Discussion (Misc queries) | |||
| Date format and Range.Find | Excel Programming | |||
| find and replace for date format | Excel Discussion (Misc queries) | |||
| macro to find date format in a cell and delete that entire row | Excel Programming | |||
Linear Mode
