=Small(If(($B$1:$B$200="Team1")+($C$2:$C$200="Team 1"),$A$1:$A$200),1)
Entered with Ctrl+Shift+Enter rather than just enter will give you the date
of the 1st game. Change the 1 to the Nth game.

This would give you the days between the 1st and second games

=SMALL(IF(($B$1:$B$200="Team1")+($C$1:$C$200="Team 1"),$A$1:$A$200),2)-SMALL(
IF(($B$1:$B$200="Team1")+($C$1:$C$200="Team1"),$A$ 1:$A$200),1)-1

Again, entered with Ctrl+Shift+Enter Rather than just enter

--
Regards,
Tom Ogilvy


"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