Day Counter

[ori kobi]

hi i have a table with date and games and i want to count the days before each game so i know how many days rest they had between each game and also see which day is the hardest.

column 1 = date
column 2 = game
column 3 = should be a day counter (-3,-2,-1...,game=0)

i cant figure it out, any idea?

 

[Peter_SSs]

I am not familiar with what this is all about and you still didn't explain how you come up with those results manually.
Why is the first result -1? Explain simply in relation to what is in the sample data.
Why is the next value also -1?
Why is the 3rd value 0?
Why is the last value 0?
When I look down the table I see some -3 values. How do you determine that the first of those should be -3?
Explain any others that get worked out a different way.

 

[Marcelo Branco]

Maybe...

Formula in D2
=B2-INDEX(B2:B$1000,MATCH("Game*",C2:C$1000,0))

Change the format of D2 to General

Drag the formula down

M.