Using a DATE/TIME field = Paper_Orders_Received_OR__c
I would like to add 8 business days to this date (Paper_Orders_Received_OR__c)
and return a new date
that auto populates a DATE field (that already has date. The new date will override the existing date).
How?
tried this one already....doesnt work for me :(
CASE(
MOD(StartDate__c - DATE(1900, 1, 7), 7),
0, (StartDate__c) + NumberOfDays__c + FLOOR((NumberOfDays__c-1)/5)*2,
1, (StartDate__c) + NumberOfDays__c + FLOOR((NumberOfDays__c)/5)*2,
2, (StartDate__c) + NumberOfDays__c + FLOOR((NumberOfDays__c+1)/5)*2,
3, (StartDate__c) + NumberOfDays__c + FLOOR((NumberOfDays__c+2)/5)*2,
4, (StartDate__c) + NumberOfDays__c + FLOOR((NumberOfDays__c+3)/5)*2,
5, (StartDate__c) + NumberOfDays__c + CEILING((NumberOfDays__c)/5)*2,
6, (StartDate__c) - IF(NumberOfDays__c>0,1,0) + NumberOfDays__c + CEILING((NumberOfDays__c)/5)*2,
null)
답변 1개
Why are you using such cumbersome formula i don't undrstand what is the criteri of .
You could try somethig like this:-
AND(
COTAINS(TEXT(Paper_Orders_Received_OR__c),""))
Then choose the workflow action as "Field update" & choose the date field which you would like to update & put the below formula:-
Paper_Orders_Received_OR__c+8
