Contents
How to calculate working days inside a workflow?
So you could in theory, do all the formula with workflow actions. This returns a numeric value for the day of the week (1 for Sunday, 2 for Monday and so on). Then you could say if 1, add 2, if 2, add 2, etc. Basically doing the same thing as your calculated formula, but with workflow actions.
How to calculate number of days since date?
To calculate the number of days since date, i.e. between a past date and today: To count the number of days until date, i.e. between a future date and today: As an example, let’s calculate the difference between today and an earlier date in A4:
What we want to do is in context for each approver level, perform the following process: Update the CurrentDate field in the CalcWorkingDays list, lookup the item by ID=1, to the current date (will be 12:00 AM as you can’t get the current date AND time)
What’s the best way to calculate working days?
Then you could say if 1, add 2, if 2, add 2, etc. Basically doing the same thing as your calculated formula, but with workflow actions. At this point you should have a couple ways to accomplish whatever you’re trying to do with working days.
Each approver gets the email, opens the form and clicks an Approve button which stores their username and date/time in the form and saves. Once the workflow wakes up from pause, we check if that level approver name is blank, and act accordingly. Mission accomplished!
How to calculate working days inside a column?
You can also find a lot of general example formulas for calculated columns on MSDN. In the original example, they were calculating 3 business days, but I needed 2. So I adjusted the formula to the following, and pasted it in the calculated column: To be sure it works, create 7 list items (one for each day of the week).
So I adjusted the formula to the following, and pasted it in the calculated column: To be sure it works, create 7 list items (one for each day of the week). Use the day of the week for the title, then just pick a matching date for that day, for each day of the week:
How to change the time to 2 working days from now?
■Update the CurrentDate field in the CalcWorkingDays list, lookup the item by ID=1, to the current date (will be 12:00 AM as you can’t get the current date AND time) ■This gives us the DATE of the proper 2 working days from now, but we need to set the time to be due at 5pm