| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using MATCH with dates
...The "Feb-06" is generated from a formula using DATEVALUE, MONTH
and DAY vs. just having a date typed into a cell) what is the formula exactly? I guess the result is text and then it is not date and will not be found in a list of dates. If the result is really a date then the day which is is hidden (and potentially the time) of the date searched is not the same as the one in the list. Regards, KL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pre-1900 dates | Excel Discussion (Misc queries) | |||
| Match Index | Excel Worksheet Functions | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| How To Match Dates | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Hybrid Mode
