Thank you, but this doesn't appear to be working beyond the first 1 or 2 in my sheet. It simply keeps repeating the same date for the last date entry of the same column AD and J.

Maybe I wasn't clear - I have thousands of unsorted items and I was hoping for an array formula that would take an entry and find the next date for each entry that had the identical column AD and column J. I can't thank you enough for your help.