In Opportunity i created a formula date field. in which i want only it take business days means like:TODAY() + ( ( ( 0.7 * ( Total_Payback_Amount__c ) ) - Total_Collected_to_Date__c ) / Daily_Payment__c ) this formula i used in formula date field.

Right now what is happening is like today is Wednesday and formula return 3 means Today + 3 = Saturday, but it should be display the date of monday.


To get you started, try this well-known formula:

CASE( MOD( Date__c - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,
"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")

Together with a case statement and a modulo operation, I'm sure you'll be able to build your formula!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.