I am in charge of scheduling for a basketball league. In simplified
terms, I have 3 columns of data - the first contains a date, the
second has Team1 and the second has Team2. A team's name can occur in
either column (just not both at the same time). I would like to be
able to see how many days are between a team's current and previous
game. The math is fairly simple, but how do you find the 4th (or 12th
or 30th) occurence of a value in a column and then reference the
corresponding date so that you can compare that to the 3rd game's
date?

Thanks in advance,
Pete