I have created a formula field
Date__c. In this date field, I want to calculate the following:
Renewal_Date__c + 1year + Extension__c
The value entered in
Extension__c is in months.
So, I have the following formula:
DATE( (YEAR( Renewal_Date__c )+1), (MONTH( Renewal_Date__c )+ Extension__c ) ,DAY( Renewal_Date__c))
The formula works fine if I leave out the
+Extension__c part. How can I make it work so that I can add the number of months as well?