Time Based Workflow on date field to consider week-days only

Question

Is there an easy way to add functionality to an existing time-workflow rule that doesn't send email alerts at the weekend?

At the moment it send out email alerts when a lead hasn't had any activity on it for 2+ days BUT, if it is created on a Friday the email will still send even if no-one had a chance to look at it as no-one works week-ends!

How do I make it ignore the ones created that day / make the 2 day timer only a WEEKDAY timer? It is currently using the system's 'last modified date' --- Do I need to create another date field instead with a formula?

Answer 1

LastModifiedDate is a misnomer - it is actually a datetime so you just need to add DATEVALUE() to the last modified date like this:

CASE( MOD(DATEVALUE( LastModifiedDate ) +2 - DATE( 1900, 1, 7 ), 7 ), ...

Answer 2

You can write a formula to get the day of the week as below. Explained in this link.

CASE(MOD( {!CloseDate} - DATE(1900, 1, 6), 7), 0, "Saturday", 1, "Sunday", 2,"Monday", 3, "Tuesday", 4, "Wednesday", 5, "Thursday", 6,"Friday","")

Assuming Saturday and Sunday are the weekends, you can create a formula to check the day of the Last Modified Date by after adding 2 days.

AND(
(CASE(MOD( LastModifiedDate +2) - DATE(1900, 1, 6), 7), 0, "Saturday", 1, "Sunday", 2,"Monday", 3, "Tuesday", 4, "Wednesday", 5, "Thursday", 6,"Friday","")<>"Saturday")
,
(CASE(MOD( LastModifiedDate +2) - DATE(1900, 1, 6), 7), 0, "Saturday", 1, "Sunday", 2,"Monday", 3, "Tuesday", 4, "Wednesday", 5, "Thursday", 6,"Friday","")<>"Sunday")
)