You need to sign in to do that
Don't have an account?
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)))
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
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
Thank you amarcute - that worked!