Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem comparing dates
I have frequent problems with dates in Excel.
I declared "dat" as a date so, "dim dat as date" I loaded it with a value from a column of dates in "tlSht" so, "dat=tkSht.Cells(r, 1)" I then tried to find the same date in a column of dates in "mst:Sht" so, "Set c = mstSht.Columns("A").Find(what:=dat)" The above works only if both date columns are formatted in the same date format and that is not feasible in my situation. I also tried using a "string" and "double" variable instead of "date", but neither worked. Can someone set me straight with this problem? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Dates | Excel Discussion (Misc queries) | |||
Comparing dates | Excel Worksheet Functions | |||
Comparing 2 Dates | Excel Worksheet Functions | |||
Comparing dates | Excel Programming | |||
Comparing two dates using between. | Excel Programming |