[SalesForce] Sending out email alert during business days

I have a process builder set up which send email alert in scheduled Action. I send an email alert after 14 days of record been created.

I want to send email alerts after 14 business days and not just 14 days. Is there a way to achieve this using process builder or Visual work flow? I do not want to use Apex since I will hit the daily limit of 1000 email that can be sent out using Mass email/ single email messaging class.

Any ideas?

Best Answer

Here the formula field to find business days. this might help for your requirement. CASE(MOD( SLAExpirationDate__c - DATE(1985,6,24),7), 0 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,3,3,4,4,5,5,5,6,5,1), 1 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,3,3,4,4,4,5,4,6,5,1), 2 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,3,3,3,4,3,5,4,6,5,1), 3 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,2,2,2,3,2,4,3,5,4,6,5,1), 4 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,1,2,1,3,2,4,3,5,4,6,5,1), 5 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,0,2,1,3,2,4,3,5,4,6,5,0), 6 , CASE( MOD( End_Date__c - SLAExpirationDate__c,7),1,1,2,2,3,3,4,4,5,5,6,5,0), 999) + (FLOOR(( End_Date__c - SLAExpirationDate__c)/7)*5)

Find more info here. https://help.salesforce.com/HTViewSolution?id=000004526

Related Topic