Accounting for the word "Perpetual" in a date field when there is no end date

Emily McNeeley

I am currently running this formula: =[Contract Expiration Date]@row - [Notify days to renew/cancel]@row to calculate the date when we need to review a contract. It essentially takes the end date of the contract and subtracts the numbers of days specified in the contract if you want to cancel. We have some contracts with no end dates that we designate as "Perpetual" in the Contract Expiration Date field. How do I update my formula to account for if Contract Expiration Date is "Perpetual" then return "Perpetual" and if not, then do the formula above?

David Tutwiler

=IF([Contract Expiration Date]@row = "Perpetual", "Perpetual", [Contract Expiration Date]@row - [Notify days to renew/cancel]@row)

That should do it

David Tutwiler

=IF([Contract Expiration Date]@row = "Perpetual", "Perpetual", [Contract Expiration Date]@row - [Notify days to renew/cancel]@row)

That should do it

Emily McNeeley

Thanks David - worked like a charm. I could have sworn I tried that but I must have missed a comma!

David Tutwiler

No worries. Very easy to do.