I have an excel file with the NBA schedule for 2024-2025.
See the photos below to help convey how the workbook is set up, what I am trying to accomplish, and the issue I am having.
I have a helper column (Column T) that searches both Column J and Column M for the team name, to help me determine the date of that team's last game, regardless of Home or Away.
helper column.png
From that, I have a formula to calculate the number of days since the teams last game, regardless of home or away, into Column I or Column N.
rest days formula.png
And from that, I have a formula to check off the box in Column F or Column O (for B2B), depending on what is in Column I or Column N.
B2B formula.png
My goal is to have a formula that checks off the box in Column G or Column P, depending on if the team is playing 3 games in 4 days, regardless if they are playing Home or Away.
The below image shows what SHOULD be checked off: The two highlighted teams (Yellow and Orange) should have a check in the checkbox, in the location indicated with the blue box, since they are playing their 3rd game in 4 days.
what SHOULD happen.png
I have tried ChatGPT4o to help me generate formulas, I have tried VBA, and nothing has worked for me....
Can someone please recommend a formula to help me accomplish this task? I am not opposed to using a different method entirely if that is what is recommended.
Here is a condensed version of the workbook.
2024 - 2025 Schedule - WIP 2.xlsx
Please help me!!!
Thank you so much!
Bookmarks