Hi All
Im hoping someone can help
Im trying to create a formula in a report to get an Opportunity Renewal date based on the Opportunity Closed Date and the Term (Cust Number field) .
For Example i have 01/05/2024 and 4.00 in the Term i would like the Formula to display 01/05/2028, obviously the term can be anything from 1 upto 10, any help would be greatly appreciated.
Then i would like to create a Formula that would work out when the discussions need to start so would need to be the Renewal data calculated using the above and then taking away 6 months off of that date.
hi @Jim . you want to see such auto-calculation in Renewal Date itself? or any other custom formula field is also fine? because if latter then you can create field with following formula to achieve the result you asked
Custom formula field of DATE as return type
IF(NOT(ISBLANK(Renewal_Date__c)) && NOT(ISBLANK(Term__c)),
DATE(YEAR(Renewal_Date__c)+VALUE(Term__c), MONTH(Renewal_Date__c), DAY(Renewal_Date__c)),
null)
Note:
1. Please replace field's name with actual API name
2. I have assumed Term is a picklist type field so I am converting the text into Number using VALUE function to add it to the year
3. I have kept criteria to make sure Renewal Date and Term field is always populated, if not. then default value will be null so you can replace default value null with your desired output
