SHarePoint list calculation qualified not weekend

0
votes

In my SharePoint list, I have a field containing one of three possible values. Depending on the value and a secondary field containing the date submitted, a due date will be calculated (adding 1, 3 or 14 days) to the date submitted but this date cannot land on a weekend and must not count the days as workdays.

I have tried numerous if, and, weekend combinations with no luck. My co-workers are also stumped.

Any assistance is greatly appreciated. Thank you

1
sharepoint-2013calculated-columns
This link might help you. But it works only for +2days. You need to modify it. Goodluck. c5insight.com/Resources/Blog/tabid/88/entryid/567/…. – jose_bacoy
Thank you, I'll play later. – Amy S

1 Answers

0
votes

Assuming a column named "Days" and a column named "TheDate" where "Days" contains the 1, 3, 14 or a formula to select one of those values.

= TheDate+Days + IF(WEEKDAY(TheDate+Days)=1,1,0) + IF(WEEKDAY(TheDate+Days)=7,2,0)

This adds the "Days" to "TheDate" and then:

  • checks to see if the new date is a Sunday, and if so, adds 1
  • checks to see if the new date is a Saturday, and if so, adds 2