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

  • 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)

    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.

  • alansidman

    Added the Label Cross Post
  • Naz92

    Moved the thread to the trash.
  • AliGW

    Restored the thread.
  • I have restored this post. Cross posting is allowed as long as you declare it (in both places) with a link. You probably need to reread the rules on both forums!

    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!