I have two columns of data, one a list of dates and the second a list of IDs. I want to calculate the difference between the date in the current row and the next largest date associated with the same ID. I am guessing that I will need to use DATEDIF, INDEX and MATCH but I am not sure how to put it all together. I guess that the final formula would resemble {=DATED IF(currentdate,(formula to find next date),"d")}.
I have tried using {INDEX(daterange,MATCH(ID,IDrange,0))} but this gives me the first date associated with the ID rather than the next largest date.
How do you find the next largest date associated with the ID value for the current date?
Any advice would be greatly appreciated, thank you.
Bookmarks