Hi
I am trying to add a formula that will show a renewal date 3 years from the subscription date (yr 1) but not show anything for implementation period or yr 2, yr 3.
IF ({Impl /Sched Fee} = Subscription Yr1), (DATEADD({Inv Date}, 3,’ years’), "None ...