Salesforce Formula to find the business days between a date field and today using Salesforce Formula #inSalesforce
Salesforce Formula to find the business days between a date field and today using Salesforce Formula
We have to create a formula field returning number and find the difference between Today and that Date field
(5 * FLOOR( ( TODAY() - DATE( 1900, 1, 8) ) / 7 )
+ MIN( 5, MOD( TODAY() - DATE( 1900, 1, 8), 7 ) )
) -
(5 * FLOOR( ( thatDate__c - DATE( 1900, 1, 8) ) / 7 )
+ MIN( 5, MOD( thatDate__c - DATE( 1900, 1, 8), 7 ) )
)
Visual: https://www.youtube.com/watch?v=Agaj3FirSA8
Comments
Post a Comment