MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
Calculating day difference for football team played from last game (rest day)
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.