I’ve extended your dashboard so that starting date can also be inputted to more easily know in which month we’re now currently. This is how it looks like:
The user can configure the start date and the sheet shows past months in light green, the current month in yellow and future months in light gray.
The user can even simply use a date picker to chose their date!
Here is a copy sheet from where you can copy the formulas and conditional formatting.
Know, that I’ve also done changes in other parts in the above sheet, so you cannot simply copy-paste the entire sheet. Please only take the specific cells with the date stuff.
What do you think?
Feel free to integrate it into your sheet if you want!