I want to update certain cells on certain days. Like on Wednesday, c8 becomes
c8+1. then like after i want on thursday and so on, c8+1 becomes the new c8
to make much easier, i'll make a timeline:
tuesday: c8 is 53
wednesday: c8 is 54
thursday: c8 is 54
next wednesday: c8 is 55
the wednesday after that: c8 is 56
In a nutshell, c8 updates weekly