+ Start a Discussion
KIBLKIBL 

Default Date to be 72hrs from today but not a weekend

I need to find a formula to default a date field to 72hrs from Case creation but the date cannot be a Saturday or Sunday.

 

Today()+3  (but cannot land on a Saturday or Sunday)

Anil KamisettyAnil Kamisetty
You can use the following Formula as the Field Update on Record Created event in the Workflow. What it does it, add number of days based on when the record was created. For example, add 3 days if the record was created on Sunday/Monday / Tuesday. Add 5 days if the record was created on Wednesday / Thursday/Friday. Add 4 days if the record was created on Saturday.

Or if you want, you can define this as the Default value for the Date field in the Field Setup too.

Today() + CASE( MOD(TODAY()-DATE(1900,1,8),7),
0,3,
1,3,
2,3,
3,5,
4,5,
5,5,
6,4,
3)

If this help, please mark it as Answered. Thus help others looking for similar solution