## Learn Salesforce Formulas with Examples – Part 9

Learn Salesforce Formulas with Examples – Part 9 is a part of the Blog Series inspired by a lot of problems related to formulas posted in Answers Community .Main motive for this blog is not to teach you how to begin with formula but how to keep a grip and make a better understanding on it. So stay tuned and I will be providing a lot of examples with explanations in this series which would help you understand more about formulas. Example 56 Here the user has three fields, “Last_Date__c” is of type Date, “Picklist__c” is a picklist and “Field C” is a formula field, now here is the use case: Based on selection of “Picklist__c” picklist value among (Monthly, Quarterly, Annually, Semi- Annually) Based on the Last Date in “Last_Date__c” “Field C” should calculate and display when is the next date of commencement of the event. Field C = Last_Date__c + CASE (Picklist__c, “Monthly”,30, “Quarterly”,91, “Semi-Annually”,182, “Annually”,365, 0) Explanation: In this formula, there are two sections, the first one returns the “Last_Date__c” of the event....

Read More