How do you calculate the next WORKDAY when the date falls on the weekend in a function field in CRM?
I am in Real Estate, and our contracts count all days in a calendar unless the date falls on a weekend day. If the due date falls on a weekend day, it rolls to the next business day date.
For example:
The inspection period is 5 days from the effective date. Effective date is Monday 9/25/2023, so the regular day count makes the due date Saturday 9/30/2023. I want the date to roll to the following Monday 10/2/2023 only if the date falls on a Saturday or Sunday.
My current function is as follows:
Adddate(${Deals.Effective Date},${Deals.Property Inspection Period},'DAY')
How can I get it to do this? Please help!