function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Workflow - skip weekends

I have the following workflow in place to populate the Due Date field based on these requirements:


CASE (Coordinator_Status__c, "Received Quote Request", Quote_Request_Received__c +1,"Received Quote and Drawing Request", Quote_Request_Received__c +4, Null)


It is working but I need it to only caculate week days.  If it is a Friday 9/17 +1, I need it to caculate to a Due Date of 9/20.  How can I make it skip weekends?




you can use this formula (straight from the help files) to calculate day of the week:


MOD(Sign_Up_Date__c - DATE(1900, 1, 7), 7)
(0 = Sunday, 1 = Monday, 2 = Tuesday, and so on)


So you can check whether the Quote_Request_Received__c is a Friday and add 1 or 3 depending on the result.


Good luck



How do I fit this with my formula?


I can add this as a validation rule but is there a way to combine the two fomulas and check for week days?