-
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
Introduction of Lightning Component Framework
Lightning component framework is a UI framework to develop dynamic mobile and desktop app. This is the framework for building single page application. In this…
Understanding Salesforce QuickStart Implementation: Top 10 Questions Answered
Why would businesses want to implement Salesforce into their business operations? Salesforce is a powerful CRM platform that is highly customizable and feature-rich, but it…
4 Phases of Salesforce Classic to Lightning Migration
Salesforce Classic to Lightning Migration offers you access to better UI, new features, and more opportunities to scale. When Salesforce Lightning was launched in 2015,…
Popular Salesforce Videos
Entrepreneurship in the Salesforce Ecosystem
The Salesforce Women’s Entrepreneur Group is a group of women who have founded and own businesses in the Salesforce ecosystem. Our goal is to inspire,…
Explore Our Salesforce Story
Explore the origins of Salesforce and how the Futureforce program came to be. Watch this video and do connect with us and share your experience…
Salesforce Introduction | Salesforce Administrator Tutorial for Beginners
Salesforce Administrators work with stakeholders to define system requirements and customize the platform. To put it simply, they enable users to get the most out…
