Hey all,

Hope all is well! I wanted to ask for a huge favor here with the workday formula.

I am looking for a formula that will calculate 6 days in the past from the start date.

Out of the 6 total count days:
Day 0: cannot count Saturday, Sunday or Holiday's
Day 1-3: cannot count Sunday or Holiday's
Day 4-6: cannot count Saturday, Sunday or Holiday's

However, the final result can only land on a Monday-Friday and not on a holiday, saturday or sunday

So if it did land on a Holiday, Saturday or Sunday, the end date would revert to the previous workday

Example:
If start date is 1/18/2022, should return 1/7/2022, NOT 1/10/2022
Day 0: 1/7 (return date) since Day 0 cannot be a Sunday (see above), so the return date should revert to the previous workday (1/7/2022)
Day 1: 1/10
Day 2: 1/11
Day 3: 1/12
Day 4: 1/13
Day 5: 1/14
Day 6: 1/18 (start date)

1/15 doesnt count since its a Saturday
1/16 doesnt count since its a Sunday
1/17 doesnt count since its a Holiday (MLK Jr)

Here is the WORKING formula in excel: 
=if(B7="CA", WORKDAY(WORKDAY.INTL(WORKDAY(AF7,-3,$A$2:$A$13),-3,11,$A$2:$A$13)+1,-1,$A$2:$A$13), AF7-4)
 

In the Loan Object in Salesforce:

B7 = ‘Property State’ loan field 

AF7 = ‘Close of Escrow’ loan field

$A$2:$A$13 = Current Holiday Date List below:

Would want to translate this formula into a Salesforce formula

Your help would be greatly appreciated!!