I am trying to create a field that will pull from 3 other fields to generate a contract termination date.
Each account has a install date (ID), contract term (CT), and renewal term (RT). For example:
Calculating the initial end date is easy (ID + CT) but I am stuck on the renewal. I want to be able to incrementally add months to the term length depending on whether or not the end date (CED) has already passed. For example:
CED=12/1/2019 (original end date)
CED=12/1/2020 (actual end date once the original has passed)
I have a formula adding the renewal term to the original contract (ID + CT + RT) but cant figure out how to add RT as many times as needed to make the CED greater than today IF(CED<=TODAY(), CED++).
Any advice would be appreciated, THANKS!