Without accounting for weekend / holiday I would just say date field plus 2 days or date field + 3 days but I'm not sure how to calculate that while accounting for weekends and holidays.
Thanks for the help in advance!
Original formula posted below:
/*((5 * ( FLOOR( ( TODAY() - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( Rate_Lock_Date__c - DATE( 1900, 1, 8), 7 ) ) )
-
(5 * ( FLOOR( ( Rate_Lock_Date__c - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( Rate_Lock_Date__c - DATE( 1900, 1, 8), 7 ) ) )
-
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-07-04"),TODAY() >= DATEVALUE("2019-07-04")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-09-02"),TODAY() >= DATEVALUE("2019-09-02")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-10-14"),TODAY() >= DATEVALUE("2019-10-14")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-11-11"),TODAY() >= DATEVALUE("2019-11-11")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-11-28"),TODAY() >= DATEVALUE("2019-11-28")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-12-25"),TODAY() >= DATEVALUE("2019-12-25")),1,0))*/
(((5 * ( FLOOR( ( TODAY() - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( TODAY() - DATE( 1900, 1, 8), 7 ) ) )
-
(5 * ( FLOOR( ( Rate_Lock_Date__c - DATE( 1900, 1, 8) ) / 7 ) ) + MIN( 5, MOD( Rate_Lock_Date__c - DATE( 1900, 1, 8), 7 ) ) ) )
-
(IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-07-04"),TODAY() >= DATEVALUE("2019-07-04")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-09-02"),TODAY() >= DATEVALUE("2019-09-02")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-10-14"),TODAY() >= DATEVALUE("2019-10-14")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-11-11"),TODAY() >= DATEVALUE("2019-11-11")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-11-28"),TODAY() >= DATEVALUE("2019-11-28")),1,0) -
IF(AND(Rate_Lock_Date__c <= DATEVALUE("2019-12-25"),TODAY() >= DATEVALUE("2019-12-25")),1,0)))
Is the goal to add two business days to Rate_Lock_date? what determines if 2 or 3 days should be added?
