3

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

3

http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List

The WORKDAY function does not exist in SharePoint

the WEEKDAY( date , [format] ) function returns the daynumber,
where sunday=1 with the default non-specified format

        WEEKDAY daystoadd   
sunday  : 1      3
monday  : 2      3
tuesday : 3      3
wednesday 4      5
thursday: 5      4
friday  : 6      3
saturday: 7      3

That makes your Formula:

= D7 + CHOOSE( WEEKDAY(D7) , 3 , 3 , 3 , 5 , 4 , 3 , 3 ) 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.