You need to sign in to do that
Don't have an account?

Next Renewal Date Field Part 2
OK now I need some help. So our opportunities have a contract length field (in years), the standard close date field and a next renewal date field which pulls from the previous two to find out when the next renewal date is. Here's the formula for the next renewal date field:
I need to change the contract length field to months, and consequently change the above formula to take it into account. Any ideas?
Code:
DATE( YEAR ( CloseDate ) + ( Contract_Length__c * (FLOOR(( TODAY() - CloseDate ) / ( Contract_Length__c * 365 )) + 1)), MONTH(CloseDate), IF( AND(DAY(CloseDate) = 29,MONTH(CloseDate) = 02) , 28, DAY(CloseDate)))
I need to change the contract length field to months, and consequently change the above formula to take it into account. Any ideas?