Forum Discussion

JennyMarshall's avatar
JennyMarshall
Qrew Trainee
7 years ago

I need a formula that says if the [Term} = 0 or N/A then Expiration Date = N/A, otherwise AdjustMonth([Term],{Effective]).

I want a formula that calculates the expiration date based on the effective date plus the term unless the term is N/A or 0 (I can do wither one), if the term is N/A or 0 then the expiration date is N/...