My client utilizes contracts and some of those contracts allow for renewals and those renewals can vary in length. We needed to be able to calculate the ultimate expiration date for all contracts.
Requirement: Determine the Ultimate Contract Expiration Date
The math: Contract End Date multiplied by Renewals Allowed_c multiplied by Length of Each Renewal_c
Formula Return Type: Date
EndDate + ((Renewals_Allowed__c * Length_of_Each_Renewal__c) * (365.25 / 12))
Thank you, SteveMo!