Salesforce Formula to find the business days between a Datetime field and TODAY using Salesforce Formula

on

Salesforce Formula to find the business days between a Datetime field and TODAY using Salesforce Formula


We have to create a formula field returning number and find the difference between Today and that Datetime field

(5 * FLOOR( ( TODAY() - DATE( 1900, 1, 8) ) / 7 ) 

    + MIN( 5, MOD( TODAY()  - DATE( 1900, 1, 8), 7 )  ) 

) - 

(5 * FLOOR( ( DATEVALUE(thatDateTime__c) - DATE( 1900, 1, 8) ) / 7 ) 

      + MIN( 5, MOD(DATEVALUE(thatDateTime__c) - DATE( 1900, 1, 8), 7 ) ) 

)


Visual: 

Comments

Post a Comment