| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare dates
Hi,
I have a worksheet that may contain up to 40K dates in a single column. The dates will be in the following format, 4/5/2012 9:14.On another worksheet, a User will enter anywhere from 5 to 12 dates in a column in the following format, 4/6/2012. What is the best way to compare the 5 to 12 dates against the 40K dates using VBA? The purpose is to determine if data was entered on day when the person was absent. Thanks. James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
| Compare dates with lag | Excel Worksheet Functions | |||
| Compare Dates in vba | Excel Programming | |||
| compare dates | Excel Worksheet Functions | |||
| how do I compare two dates? | Excel Worksheet Functions | |||
Threaded Mode
