-
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
What is Salesforce Service Cloud in 2024?
Salesforce Service Cloud is one of the platforms in the Salesforce ecosystem designed to optimize customer service and support processes. Service Cloud offers a variety…
Common Mistakes while Performing Salesforce Integration: What not to do
Integration means combining two different systems, portals, applications, etc with each other in order to make them as one application. Integration is very widely implemented…
What Makes Salesforce CRM A Right Fit For Any Business Size?
What comes to your mind when I say the term an effective Customer Relationship Management? Did the bright smiles or over-enthusiastic thank you replies of…
Popular Salesforce Videos
Generate the Multiple Contracts in Salesforce CPQ
In this video, watch a demonstration of how to generate multiple contracts using a single quote record. Watch and learn. Do let us know in…
Salesforce Lightning Events Tutorial I Building Component Events (Single Component)
This Salesforce Lightning Events Tutorial will make you learn how to register an event in Salesforce Lightning and handle that event in the source component…
Getting Started With Business Analysis | Scrum Development Model | Salesforce Tutorial
Learn all about AGILE software development and the scrum development model. 1. Introduction To AGILE Get a brief definition of AGILE and its different modules.…