Forum Discussion
Solved
Different cell advance one month
Hi,
Beginner here. I have a sheet that tracks customer payments. I'm trying to come up with a solution where entering a date in one cell advances a set cell one month. For example, entering the pay...
Resolved, Please download my attachment and reply if you need any assistance.
Thank you, Gourab. Yes, that is the solution for one month. Is there a way to affect the same cell as the months advance?
just change the sign from "+" to "-"
Gourab,
I do thank you for your replies. However, I'm quite new at this and am unaware where to put the + or -. Also, just wanted to confirm that we are only affecting the one cell, so that whichever month we pick, it will advance the 'due' cell one month.
Mark
Well, I had hoped to resolve this. I don't understand the solution, so I found another one. I deleted the 'Due' row and added Conditional Formatting to the months so that any cell with a date a month in advance shows a red fill.