I have a column named "Date received" and I need to calculate a "Date Due".
The due date is 3 calendar days after received however if that falls on a weekend it needs to be the next business day. I've been messing with this way too long and can't get it to work. I can get it in excel but not sharepoint.
my eq in excel was =IF(OR(WEEKDAY(D7+3)=7,WEEKDAY(D7+3)=1),WORKDAY(D7+3,1),D7+3)
D7=[date received]
I'm using SharePoint Online (Office 365).
Any help would be great