Calculating day difference for football team played from last game (rest day)

Hello there!

I'm new to here and I'm very grateful if anyone can help me with my post.

So, here is my question. I have a spreadsheet on Austrian Football Bundesliga consist of several column such as date, name of team, stats and etc.

What I would like to do is to create two columns for my table to have a day difference (rest day) of each team's from previous game before play next game, so it would show the number of days as gap between date of previous game that they have played until next game as rest day for both home and away team before they play for the next game. I have searched all around the web but haven't found anything that can help me. I know some basic formula to calculate days difference but I can't do that for all matches accordingly to the specific teams.

Please see attached for your reference. If anyone could help that would be great.
Thank you.

Dear alansidman,

I'm so sorry for my carelessness and breaking the rules. Thank you for reminding me and gave me another chance. I'm already delete my other post.

Thank you.

Try this, H2=IFERROR(XLOOKUP(B2,B3:B$3062,$A3:$A$3062)-$A2,""), copy down and across.

Originally Posted by josephteh

Try this, H2=IFERROR(XLOOKUP(B2,B3:B$3062,$A3:$A$3062)-$A2,""), copy down and across.

Hi josephteh,

Thank you for your help and I really appreciate it. I already try it but it only cover Home Team only. It should cover both date for home and away team. The initial value for 1st match should start with 0 because there is no date for previous match. Here, I attach a image for your reference. Thank you again. Attachment 803782

Your attachment is not valid.

Originally Posted by josephteh

Your attachment is not valid.

Sorry, I reupload back my attachment.

Try this, =LET(x,MAX(XLOOKUP(B2,$B$1:$B1,$A$1:$A1,0,0,-1),XLOOKUP(B2,$C$1:$C1,$A$1:$A1,0,0,-1)),IF(x=0,0,$A2-x))

Originally Posted by josephteh

Try this, =LET(x,MAX(XLOOKUP(B2,$B$1:$B1,$A$1:$A1,0,0,-1),XLOOKUP(B2,$C$1:$C1,$A$1:$A1,0,0,-1)),IF(x=0,0,$A2-x))

Sorry again since I miss to highlight 12/7/2000 but its work perfectly. Thank you so much.

Originally Posted by HansDouwe

Or try this formula in H2 and copy across and down:

Formula:

Please Login or Register  to view this content.

FC Innsbruck played also 12/7/2000 so this formula returns 7 in H17 instead of 15.

Thank you to point out the date that I miss to highlight. Its works perfectly too. I really appreciate and thanks to both of you. I will break down this formulas to learn and understand it.

Actually I quiet panic during that time. So, I delete the post without hesitation. After that I realize that cross posting is allowed as long as I declare it in both forums. I already mark this thread as SOLVED. Thank you AliGW for reminder

Hans' formula is much better and shorter as well!