I just figured out a way to have the in-game date shown in my spreadsheet, and wondered if anyone knew of a more efficient way to represent this.
To get "S43 M10" I am using the following:
Code: Select all
I was using multiple cells to compute the same information, [i.e. C1 =TODAY(), C2 =DATE(2012,07,12) ] but personally, I'd rather have the equation in one cell.
The date was chosen because at the moment it returns the right result. It probably isn't the day the site opened because there have been a few days where the match engine broke and had to be redone.
It's also not entirely future-proof, because there is always a chance that the match engine will repeat days again.