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