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?
Tia, Lily.
DATE( (YEAR( Renewal_Date__c )+1), (MONTH( Renewal_Date__c + Extension__c )) ,DAY( Renewal_Date__c))
, the month value is simply ignored.Data Type = Number
. I tried hardcoding something, and that also gave me an error. When I write:DATE( (YEAR( Renewal_Date__c )+1), (MONTH( Renewal_Date__c )+ 9 ) ,DAY( Renewal_Date__c))
, I would expect to add an additional 9 months, but it seems this is not the case. I get an error in the field instead. Maybe I am using the months calculation incorrectly...