Forum Discussion
Adding Date excluding weekends for +10 days
DueDate = VAR _P1 = Test274DateAddExcludeWeekends[CreatedDate] + TIME(2,0,0) VAR _P2 = Test274DateAddExcludeWeekends[CreatedDate] + TIME(8,0,0) VAR _P3 = Test274DateAddExcludeWeekends[CreatedDate]...
Hi Anonymous ,
For your requirement, you could use the logic of your previous post which has been solved.
You could change the formula be like below.
VAR_P2=Test274DateAddExcludeWeekends[CreatedDate] + DAY(DATE(0,0,10))
Please have a try, if you still need help, please share your data sample which could reproduce your scenario and your desired output so that we could help further on it.
Best Regards,
Cherry
I dont see an option to attach files in this forum. Hence Pasted as screenshot. and data as table.
If you look at the below screenshot. the date for P3 calculation is set to P3 created date + 10 but the new date is not excluding weekends.
| ID | Module | Priority | Created | Resolved | Due Date |
| 2 | Incident | 1 | 22/03/2019 14:00 | 25/03/2019 16:00 | |
| 3 | Incident | 1 | 22/03/2019 23:00 | 22/03/2019 15:00 | |
| 4 | Incident | 2 | 22/03/2019 14:00 | ||
| 5 | Incident | 3 | 22/03/2019 14:00 | ||
| 6 | Incident | 4 | 22/03/2019 14:00 | ||
| 7 | Incident | 4 | 23/03/2019 14:00 | ||
| 8 | Incident | 4 | 24/03/2019 14:00 | ||
| 9 | Incident | 4 | 25/03/2019 14:00 | ||
| 10 | Incident | 4 | 26/03/2019 14:00 | ||
| 11 | Incident | 4 | 27/03/2019 14:00 | ||
| 12 | Incident | 4 | 28/03/2019 14:00 | ||
| 13 | Incident | 4 | 29/03/2019 14:00 | ||
| 14 | Incident | 4 | 30/03/2019 14:00 | ||
| 15 | Incident | 4 | 31/03/2019 14:00 | ||
| 16 | Incident | 4 | 01/04/2019 14:00 | ||
| 17 | Incident | 4 | 02/04/2019 14:00 | ||
| 18 | Incident | 4 | 03/04/2019 14:00 | ||
| 19 | Incident | 4 | 04/04/2019 14:00 | ||
| 20 | Service Request | 1 | 22/03/2019 14:00 | ||
| 21 | Service Request | 2 | 22/03/2019 14:00 | ||
| 22 | Service Request | 3 | 22/03/2019 14:00 | ||
| 23 | Service Request | 4 | 22/03/2019 14:00 | ||
| 24 | Service Request | 3 | 26/03/2019 21:00 | ||
| 25 | Incident | 5 | 22/03/2019 14:00 | ||
| 26 | Incident | 6 | 22/03/2019 14:00 | ||
| 27 | Incident | 7 | 22/03/2019 14:00 | ||
| 28 | Incident | 8 | 22/03/2019 14:00 | ||
| 29 | Incident | 9 | 22/03/2019 14:00 |