+ Start a Discussion
janeisaacjaneisaac 

Formula to calculate new renewal date based on # of months in renewal term

I am trying to automate the Contract End Date for a renewal term.

I have a custom date field with the Renewal Term Start Date and the number of months in the renewal term.

I want a formula to deliver the new Contract End Date and take into consideration the possibilities of Leap Years.

 

I found a formula (below) on the board that calculates the new date when it is a year later. I know I have to convert the number of months into days first but that will depend on the start date. I am lost as to how to tackle this. Can someone take a shot at this for me?

 

 

DATE(
YEAR (AppDate__c) + (FLOOR((TODAY() - AppDate__c) / 365.2425) + 1),
MONTH(AppDate__c),
IF(AND(DAY(AppDate__c) = 29,MONTH(AppDate__c ) = 02) , 28, DAY(AppDate__c)))

Best Answer chosen by Admin (Salesforce Developers) 
amarcuteamarcute

Hi,

 

Check this solution which solved a similar kind of issue. This may be of some help.

 

http://boards.developerforce.com/t5/Formulas-Validation-Rules/Calculate-renewal-date-from-close-date-in-an-opportunity/td-p/160598

 

 

All Answers

amarcuteamarcute

Hi,

 

Check this solution which solved a similar kind of issue. This may be of some help.

 

http://boards.developerforce.com/t5/Formulas-Validation-Rules/Calculate-renewal-date-from-close-date-in-an-opportunity/td-p/160598

 

 

This was selected as the best answer
janeisaacjaneisaac

Thank you amarcute - that worked!