+ Start a Discussion

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:

YEAR ( CloseDate ) + (  Contract_Length__c  * (FLOOR(( TODAY() - CloseDate ) / (  Contract_Length__c  * 365 ))  + 1)),
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?