Our users would like the task due date to default to 2 business days from the date the task is created. Ex) if the task is created on a wednesday, the due date should be Friday and if the task if created on Thursday, the due date should be Monday. We have tried several formulas in the the default value (global actions) but they only work half the time. Has anyone had any success with this?
Below are the formulas we have tried already that haven't worked (we've been checking every day):
- CASE( MOD(TODAY() - DATE(1900, 1, 7), 7), 3, TODAY() + 2 + 2, 4, TODAY() + 2 + 2, 5, TODAY() + 2 + 2, 6, TODAY() + 1 + 2, TODAY() + 2 )
- CASE(MOD(TODAY-DATE(1900,1,7),7),3,TODAY+2+3,4,TODAY+2+3,5,TODAY+2+3,6,TODAY+1+3,TODAY+3)
- CASE(WEEKDAY(TODAY()),3, TODAY() + 2 + 2,4, TODAY() + 2 + 2,5, TODAY() + 2 + 2,6, TODAY() + 1 + 2,TODAY() + 2)
11 risposte
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Forget my last comment, you coudl use TODAY() instead of DATEVALUE(CreatedDate):
TODAY()+
CASE(WEEKDAY(TODAY()),5,4,6,4,7,3,2)