Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
janeisaac

# 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)))

amarcute

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

amarcute

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
janeisaac

Thank you amarcute - that worked!