You are here

Skipping weekend for SharePoint Calculated Columns- Due date type stuff

I need to allow the staff to enter a date and base on that date, administer tests based on that date.There will also be a flow that notifies another user that they are scheduled to take a test.

I created Calculated columns so it would automatically generate the dates as soon as the staff members enter a start date.
We do not test over the weekend so I needed to take out saturdays and sundays.

Test are two days apart during a normal work week. So I need every one who starts or completed a test on Thursday or Friday to complete their next test on the following Monday.

 

Here is the column formula

=IF(WEEKDAY([YourDateColumn])=5,[YourDateColumn]+4,IF(WEEKDAY([YourDateColumn])=6,[YourDateColumn]+3,[YourDateColumn]+2))

(=5 is Thursday and =6 is Friday)

Mine:laugh

=IF(WEEKDAY([TestToStay-StartDate])=5,[TestToStay-StartDate]+4,IF(WEEKDAY([TestToStay-StartDate])=6,[TestToStay-StartDate]+3,[TestToStay-StartDate]+2))

 

 

Yay!