+ Start a Discussion
KIBLKIBL 

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?

mpannmpann

Hi,

 

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

 

KIBLKIBL

How do I fit this with my formula?

KIBLKIBL

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