This formula will not work as this is the default value and CreatedDate cannot be used:
CASE(MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ),
0, CreatedDate + 1 + 2,
4, CreatedDate + 2 + 2,
5, CreatedDate + 2 + 2,
6, CreatedDate + 2 + 2,
CreatedDate + 2
)
This formula does not consider business days: NOW() + 72/24
Can someone help?
12 respuestas
Your Field Update Formula would be something like this: TODAY() +
CASE(
MOD( TODAY() - DATE( 1900, 1, 7 ), 7 ),
3, (2 + 3),
4, (2 + 3),
5, (2 + 3),
6, (1 + 3),
3)
