Timeline for Business day formula help
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 12, 2018 at 1:20 | comment | added | Dean M. | Is it working for you now? | |
| Oct 10, 2018 at 20:03 | comment | added | user60972 | CASE( MOD(Application_Created_Date__c - DATE(1900, 1,7),7), 0, (Application_Created_Date__c) + 3 + FLOOR((3-1)/5)*2, 1, (Application_Created_Date__c) + 3 + FLOOR((3)/5)*2, 2, (Application_Created_Date__c) + 3 + FLOOR((3+1)/5)*2, 3, (Application_Created_Date__c) + 1 + FLOOR((3+2)/5)*2, 4, (Application_Created_Date__c) + 2 + FLOOR((3+3)/5)*2, 5, (Application_Created_Date__c) + 2 + CEILING((3)/5)*2, 6, (Application_Created_Date__c) - IF(4>0,1,0) + 3 + CEILING((3)/5)*2, null) | |
| Oct 10, 2018 at 13:52 | comment | added | user60972 | I have entered this formula and it is still counting Sunday. It's exactly how you have it. | |
| Oct 9, 2018 at 21:20 | history | answered | Dean M. | CC BY-SA 4.0 |