I'm looking to add a round or week count to some sports data (so that I can do something else with the round or week number) and I have fixtures for this year's English Premiership based on the date played. You can see that I have managed to figure out the first bit (cell H13, where I have treated the opening day of the season in B2 as effectively the starting point) and was intending to reference everything from here (e.g. after 7 days would be week 2, 14 days from B2 would be week 3 etc.).
I was thinking that I could do a massive IF formula with say 38 terms for 38 weeks, but wondered if there was a slightly more elegant way of doing this.
I'd be grateful for anyone's advice on this and am quite happy to discuss.
Thanks in advance,
Fixtures_Adjustment_12_13.xls
Bookmarks