I have a custom date field called "payment_due_date__c" and a formula field called "reminder_date__c". I want to display a date in the reminder date field equal to 5 business days prior (not including holidays) to the value in the payment due date field. Business days are defined as Monday - Friday
I did some searching and found other solutions that return the number of days, but I want to return a date value instead.
I have this which is close, but not quiet there:
CASE( MOD( payment_due_date__c- DATE( 1900, 1, 7 ), 7 ), 3, payment_due_date__c- 2 - 2, 4, payment_due_date__c- 2 - 3, 5, payment_due_date__c- 2 - 4, 6, payment_due_date__c- 1 -5, payment_due_date__c- 5 )