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:
=IF(WEEKDAY([TestToStay-StartDate])=5,[TestToStay-StartDate]+4,IF(WEEKDAY([TestToStay-StartDate])=6,[TestToStay-StartDate]+3,[TestToStay-StartDate]+2))
Yay!