Forum Discussion

Mark Salmi's avatar
Mark Salmi
Copper Contributor
Apr 06, 2018

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 payment date for January will advance the date in the 'Due' cell. Completing the date in the rest of the months affect the same cell. Or, even simpler, just applying a cell style (change the month cell to green) does the same thing. Thanks in advance for your help.

 

Mark

    • Mark Salmi's avatar
      Mark Salmi
      Copper Contributor

      Thank you, Gourab. Yes, that is the solution for one month. Is there a way to affect the same cell as the months advance?

Resources