Caution with CASE statements in a Salesforce formula

The bold statement: CASE formula always calculates all values (including else) even if a condition has already been met. Use case: Create a formula field to calculate the 1st day of next month from closedate (for simplification lets assume all months have...

The ultimate Salesforce formula to add business days to a date (part-2)

In the previous post we saw how we can add business days into a date to get a new date. This was posted here. In this post, we will do the same thing but a bit more cleverly. The logic:...

The ultimate Salesforce formula to add business days to a date (part-1)

Lets says we have a date, call it Just_a_date__c And we have number of business days, call it Number_of_business_days_to_add__c Business day in this context means Monday to Friday (gosh thank god for a 5 days working week for me and...