You need to sign in to do that
Don't have an account?
KIBL
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?
Hi,
you can use this formula (straight from the help files) to calculate day of the week:
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?