You need to sign in to do that
Don't have an account?
KIBL
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)
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