-
How to calculate days between two DateTime values excluding weekends?
How to calculate days between two DateTime values excluding weekends?
-
2 Replies
-
Hi Himanshu,
You can use the below formula:
CASE(MOD( StartDate__c - DATE(1985,6,24),7),
0 , CASE( MOD( EndDate__c - StartDate__c ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
1 , CASE( MOD( EndDate__c - StartDate__c ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
2 , CASE( MOD( EndDate__c - StartDate__c ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
3 , CASE( MOD( EndDate__c - StartDate__c ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
4 , CASE( MOD( EndDate__c - StartDate__c ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
5 , CASE( MOD( EndDate__c - StartDate__c ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
6 , CASE( MOD( EndDate__c - StartDate__c ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
999)
+
(FLOOR(( EndDate__c - StartDate__c )/7)*5)Thanks
-
(5 * FLOOR( ( DATEVALUE(End_Date__c) - DATE( 1900, 1, 8) ) / 7 ) + MIN( 5, MOD( DATEVALUE(End_Date__c) - DATE( 1900, 1, 8), 7 ) ) ) - (5 * FLOOR( ( DATEVALUE(Start_Date__c) - DATE( 1900, 1, 8) ) / 7 ) + MIN( 5, MOD( DATEVALUE(Start_Date__c) - DATE( 1900, 1, 8), 7 ) ) )
Here Start_Date__c is earlier date and End_Date__c is new one which is less than Start_Date__c
Log In to reply.
Popular Salesforce Blogs
Salesforce Chatbots are Changing the Customer Service Game
Chatbot, A brief A chatbot (short for "chat robot") is computer software that replicates genuine interaction via voice or text. Such programs are adaptable and…
What is the Process Builder in Salesforce? | The Ultimate Guide
What is the Process Builder? The Process Builder is a visual tool that allows users to build complex business processes using a drag-and-drop interface. It…
Salesforce Standard APIs - All You Need to Know
Salesforce is becoming the #1 CRM tool and continually advancing with new features and functionalities that everyone wants to take benefit of eagerly. While working…
Popular Salesforce Videos
How the Salesforce Ecosystem Helped My Career
Welcome back to 100DaysofTrailhead.com! Your involvement in the Salesforce Ecosystem can be a great boost to your career. In this video, Eric talks about the…
Salesforce SOAP API integration using Partner WSDL
This video is another one on our Salesforce Integration learning video series, through this video our experts will be going to demonstrate how to use…
Improve Your Front and Backend Team Collaboration With Sinergify | Salesforce CRM
Businesses that use Salesforce CRM and Atlassian Jira separately face a lack of team collaboration, inconsistent customer data, slower case resolution, and reduced agent productivity.…
