Overview
Say a user creates a item in a list and they have 3 (working days) to to mark it as completed, how do we do this?
1. Create a new field in the list (calculated field of type date and time), lets call it "escalate date", then using this formula.
=IF(Weekday([Modified])>3, [Modified]+5, IF(Weekday([Modified])>1,[Modified]+3, [Modified]+4))
2. Create a workflow that starts on item created and changed, that pauses until the "escalate date", once that date is reached, workflow checks if item was marked as completed or not.
Explanation of Weekday.
Using Weekday, we can determine which day of the week the share point list item was created and add 3 working days to a calculated column.
| Weekday | Returns | Days to add | Escalate Date |
| Sunday | 1 | +4 | Thursday |
| Monday | 2 | +3 | Thursday |
| Tuesday | 3 | +3 | Friday |
| Wednesday | 4 | +5 | Monday |
| Thursday | 5 | +5 | Tuesday |
| Friday | 6 | +5 | Wednesday |
| Saturday | 7 | +5 | Thursday |
