Spreadsheet: 798322d1664424339-find-out-the-date-when-the-next-match-is-played-from-a-list-data
Sheet: Sheet1

Date | Home Team (H) | Away Team (A) | Winner | Home Odds | Away Odds | Fav | Dog | Winner | W | Winning Fav | Losing Fav | Next date played(maually typed) | formulated date
2021-12-05 00:00:00 | [NAME] | [NAME] | H | 1.65 | 2.27 |  |  |  | W
2021-12-06 00:00:00 | [NAME] | [NAME] | H | 1.65 | 2.24 |  |  |  | W |  |  |  |  |  |  | Problem:
2021-12-07 00:00:00 | Melbourne Renegades | Adelaide Strikers | H | 2.57 | 1.52 |  |  |  | W |  |  | 2021-12-09 00:00:00 | formula to produce the same date |  |  | 1. Adelaide Strikers lost the game on 7/12/2021
2021-12-08 00:00:00 | [NAME] | [NAME] | H | 1.69 | 2.17 |  |  |  | W |  |  |  |  |  |  | 2. Adesliade strikers played their next game on 9/12/2021 , irrespective of being a home team or away team. I want the date to be popluated through a formula
2021-12-08 00:00:00 | [NAME] | [NAME] | A | 2.02 | 1.78 |  |  |  | W |  |  |  |  |  |  | 3. Repeat the formula for all the teams listed on Column L
2021-12-09 00:00:00 | Adelaide Strikers | Melbourne Renegades | H | 1.71 | 2.14 |  |  |  | W
2021-12-10 00:00:00 | [NAME] | [NAME] | H | 1.72 | 2.07 |  |  |  | W |  |  |  |  |  |  | Expected solution:
2021-12-11 00:00:00 | [NAME] | Adelaide Strikers | H | 1.68 | 2.2 |  |  |  | W |  |  |  |  |  |  | When did the team in Column L  played their next game either as home or away team?
2021-12-12 00:00:00 | [NAME] | [NAME] | A | 2.38 | 1.58 |  |  |  | W
2021-12-13 00:00:00 | [NAME] | Melbourne Renegades | H | 1.57 | 2.4 |  |  |  | W
2021-12-14 00:00:00 | [NAME] | [NAME] | A | 2.12 | 1.73 |  |  |  | W
2021-12-15 00:00:00 | [NAME] | [NAME] | A | 1.81 | 2 |  |  |  | W |  |  | 2021-12-24 00:00:00
2021-12-19 00:00:00 | [NAME] | [NAME] | A | 1.87 | 1.9 |  |  |  | W |  |  | 2021-12-23 00:00:00
2021-12-20 00:00:00 | [NAME] | [NAME] | H | 1.65 | 2.23 |  |  |  | W
2021-12-21 00:00:00 | [NAME] | Adelaide Strikers | H | 1.57 | 2.4 |  |  |  | W
2021-12-22 00:00:00 | Melbourne Renegades | [NAME] | A | 2.45 | 1.56 |  |  |  | W
2021-12-23 00:00:00 | Adelaide Strikers | [NAME] | A | 1.66 | 2.22 |  |  |  | W |  |  | 2021-12-27 00:00:00
2021-12-24 00:00:00 | [NAME] | [NAME] | H | 2.15 | 1.7 |  |  |  | W |  |  | 2021-12-27 00:00:00
2021-12-26 00:00:00 | [NAME] | Melbourne Renegades | H | 1.43 | 2.87 |  |  |  | W
2021-12-26 00:00:00 | [NAME] | [NAME] | A | 1.89 | 1.93 |  |  |  | W |  |  | 2021-12-28 00:00:00
2021-12-27 00:00:00 | [NAME] | [NAME] | A | 2.22 | 1.66 |  |  |  | W
2021-12-27 00:00:00 | [NAME] | Adelaide Strikers | H | 1.61 | 2.27 |  |  |  | W
2021-12-28 00:00:00 | [NAME] | [NAME] | H | 2.35 | 1.6 |  |  |  | W |  |  | 2022-01-02 00:00:00
2021-12-29 00:00:00 | Melbourne Renegades | [NAME] | A | 2.22 | 1.67 |  |  |  | W
2021-12-29 00:00:00 | [NAME] | [NAME] | H | 1.59 | 2.36 |  |  |  | W
2021-12-31 00:00:00 | Adelaide Strikers | [NAME] | A | 1.72 | 2.1 |  |  |  | W |  |  | 2022-01-02 00:00:00
2022-01-01 00:00:00 | [NAME] | [NAME] | A | 1.53 | 2.5 |  |  |  | W |  |  | 2022-01-05 00:00:00
2022-01-02 00:00:00 | [NAME] | Adelaide Strikers | H | 1.85 | 1.97 |  |  |  | W
2022-01-02 00:00:00 | [NAME] | [NAME] | A | 3.03 | 1.4 |  |  |  | W
2022-01-03 00:00:00 | [NAME] | Melbourne Renegades | A | 2.76 | 1.44 |  |  |  | W
2022-01-04 00:00:00 | [NAME] | [NAME] | H | 2.17 | 1.68 |  |  |  | W |  |  | 2022-01-09 00:00:00
2022-01-05 00:00:00 | Adelaide Strikers | [NAME] | H | 2.15 | 1.71 |  |  |  | W |  |  | 2022-01-08 00:00:00
2022-01-06 00:00:00 | [NAME] | [NAME] | A | 2.06 | 1.77 |  |  |  | W
2022-01-06 00:00:00 | Melbourne Renegades | [NAME] | H | 1.26 | 4 |  |  |  | W
2022-01-08 00:00:00 | [NAME] | [NAME] | A | 4.25 | 1.23 |  |  |  | W
2022-01-08 00:00:00 | Melbourne Renegades | [NAME] | A | 2.12 | 1.74 |  |  |  | W
2022-01-09 00:00:00 | [NAME] | [NAME] | A | 1.9 | 1.94 |  |  |  | W |  |  | 2022-01-11 00:00:00
2022-01-10 00:00:00 | [NAME] | Adelaide Strikers | H | 1.72 | 2.15 |  |  |  | W
2022-01-10 00:00:00 | [NAME] | [NAME] | A | 2.31 | 1.62 |  |  |  | W
2022-01-11 00:00:00 | Melbourne Renegades | [NAME] | A | 2.12 | 1.73 |  |  |  | W
2022-01-11 00:00:00 | [NAME] | [NAME] | H | 1.96 | 1.78 |  |  |  | W |  |  | 2022-01-13 00:00:00
2022-01-12 00:00:00 | [NAME] | Adelaide Strikers | A | 1.84 | 1.98 |  |  |  | W |  |  | 2022-01-16 00:00:00
2022-01-13 00:00:00 | Melbourne Renegades | [NAME] | A | 2.39 | 1.56 |  |  |  | W
2022-01-13 00:00:00 | [NAME] | [NAME] | A | 1.68 | 2.21 |  |  |  | W |  |  | 2022-01-15 00:00:00
2022-01-14 00:00:00 | Adelaide Strikers | [NAME] | H | 2.44 | 1.57 |  |  |  | W |  |  | 2022-01-17 00:00:00
2022-01-15 00:00:00 | [NAME] | [NAME] | H | 2.06 | 1.77 |  |  |  | W |  |  | 2022-01-19 00:00:00
2022-01-15 00:00:00 | Adelaide Strikers | [NAME] | H | 2.49 | 1.54 |  |  |  | W |  |  | 2022-01-16 00:00:00
2022-01-16 00:00:00 | [NAME] | [NAME] | H | 1.56 | 2.43 |  |  |  | W
2022-01-17 00:00:00 | [NAME] | [NAME] | A | 2.7 | 1.47 |  |  |  | W
2022-01-17 00:00:00 | Adelaide Strikers | [NAME] | H | 2.41 | 1.57 |  |  |  | W |  |  | 2022-01-19 00:00:00
2022-01-18 00:00:00 | [NAME] | Melbourne Renegades | H | 1.45 | 2.78 |  |  |  | W
2022-01-19 00:00:00 | [NAME] | [NAME] | H | 1.76 | 2.02 |  |  |  | W
2022-01-19 00:00:00 | [NAME] | Melbourne Renegades | H | 1.36 | 3.11 |  |  |  | W
2022-01-19 00:00:00 | [NAME] | [NAME] | A | 2.26 | 1.63 |  |  |  | W
2022-01-21 00:00:00 | Adelaide Strikers | [NAME] | H | 1.76 | 2.06 |  |  |  | W
2022-01-22 00:00:00 | [NAME] | [NAME] | H | 1.64 | 2.27 |  |  |  | W
2022-01-23 00:00:00 | [NAME] | Adelaide Strikers | A | 1.72 | 2.14 |  |  |  | W |  |  | no games to play
2022-01-26 00:00:00 | [NAME] | Adelaide Strikers | H | 2.2 | 1.69 |  |  |  | W |  |  | no games to play
2022-01-28 00:00:00 | [NAME] | [NAME] | H | 1.45 | 2.81 |  |  |  | W