Thanks for that, but I need a formula that will work out the values in column c. I worked it out manually for the example, I have over 100,000 rows of interaction date data that I need to figure out an average elapsed days per subject.