I should have mentioned it gives the answer in days, if it shows up as
a date, simply format the cells as general or number

Dan E

"Dan E" wrote in message ...
Pete,

Add 2 more columns - Team1 Next Game and Team 2 Next Game.
Assuming your data goes from A2:C100
In D2 (Team1 Next Game) put
=INDEX(A3:A100,IF(ISERROR(MATCH(B2,B3:B100,0)),IF( ISERROR(MATCH
(B2,C3:C100,0)),"n",MATCH(B2,C3:C100,0)),MATCH(B2, B3:B100,0)))-A2

In E2 (Team2 Next Game) put
=INDEX(A3:A100,IF(ISERROR(MATCH(C2,B3:B100,0)),IF( ISERROR(MATCH
(C2,C3:C100,0)),"n",MATCH(C2,C3:C100,0)),MATCH(C2, B3:B100,0)))-A2

Fill these two columns down this will give you columns showing
when each team's next game is.

Dan E

"Pete" wrote in message om...
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