Nov 25 2020 12:46 AM
We have newsletters that are renewed each year if the customer has paid. I am trying to set up a formula that says if cell (x) = Y then move the date in cell (y) forward a year. I am struggling to get this to work would anyone know how to do this?
Nov 25 2020 12:57 AM
@Hrdevelop45
In general that is job for VBA programming. There is the trick to use formulas enabling iterative calculations, first sample I found is Create A Timestamp In Excel With Formulas - How To Excel At Excel
Nov 25 2020 01:09 AM
@Sergei Baklan thank you I will take a look.