| ID | Date | ID | Date | ||
| 1 | 1/1/2015 | 1 | 1/11/2015 | ? | |
| 1 | 1/10/2015 | 2 | 2/17/2015 | ? | |
| 1 | 1/14/2015 | 3 | 4/5/2015 | ? | |
| 2 | 2/4/2015 | ||||
| 2 | 2/8/2015 | ||||
| 2 | 3/11/2015 | ||||
| 3 | 4/1/2015 | ||||
| 3 | 4/7/2015 Hi: I would like to have a formula that will look through a list of dates (column 2) and return the closest NEXT date to the date in the 5th column for each of the IDs. I have tried using INDEX MIN MATCH, but this is returning the most recent date, not the one closest. Thank you! |
<tbody>
</tbody>
