I have two fields in a particular opportunity. One is the "Proposal Sent Date" which is automatically entered when the user generates the proposal (via Conga Composer). I also have the "Proposal Valid Thru Date" which should be 1 month (or 31 days for simplicity) after the Proposal Sent Date. HOWEVER, this valid thru date cannot be on the weekend.
My question is, how can I turn:
Proposal Valid Thru Date (Date)= Proposal_Sent_Date__c + 31
Into a field that will push the date 2 days forward if it is a Saturday, and 1 day forward if it is a Sunday?
For instance, If I ran that report today, the sent date is 5/4/2017 but the Valid date is 6/4/2017 which is a Sunday. I need that to know 6/4/2017 is a Sunday and to add a day to make the valid thru date 6/5/2017 which is Monday
I am looking for my answer to be solved directly in the Formula Field.