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.
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
