| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the position of a date
Perfect! , Thanks again
This is what I was looking for: "If you also want "doesn't exist" if B1:B2 is later (more recent) than the first month/year represented in A1:A100, then: =IF(OR(DATE(B2,B1,1)<A100-DAY(A100),DATE(B2,B1,0)A1-DAY(A1)), "doesn't exist", MATCH(DATE(B2,B1,1),A1:A100,-1)) Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you find the position of the first value (< 0) in a list | Excel Discussion (Misc queries) | |||
| Array to find relative position - is there a better way? | Excel Worksheet Functions | |||
| How do I find the position of the lowest value in a row? | Excel Discussion (Misc queries) | |||
| find nth position of a string | Excel Discussion (Misc queries) | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Hybrid Mode
