I am quite new to Google Sheets and I am wondering if someone can help me as I am looking to update a cell by +1 each time a certain date comes about.
I currently have;
- =today cell
- Counter cell (This will be the one rising by +1 each time the =today hits a certain day of the month)
- A monthly cost cell which I will subtract from a total cell
- A total cell which should decrease by the monthly cost each time the counter rises.
I already have a setup where If I manually add 1 to the counter cell then the total cell decreases as I want it but is there an automatic way by using the date? Say if the =today turns the 25th and a cell is assigned to the 25th then the counter goes up automatically.