you can use below calc.
IF DATENAME('weekday',[Order Date])<>'Saturday'
AND DATENAME('weekday',[Order Date])<>'Sunday'
AND [Order Date]<>DATE('112019')
AND ([Order Date])<>DATE('04/19/2019')
AND [Order Date]<>DATE('4/22/2019')
AND [Order Date]<>DATE('5/6/2019')
AND [Order Date]<>DATE('5/27/2019')
AND [Order Date]<>DATE('8/26/2019')
AND [Order Date]<>DATE('12/25/2019')
AND [Order Date]<>DATE('12/26/2019')
THEN [Order Date] END
you can replace ""Order date"" with ""Target Date"
Let me know if it helps, in that case you can mark it answered.
Thanks, but that's not what I'm looking for.
This will exclude these dates for sure, however, Target Date will not be calcuated considering weekends, holidays in between, and SLA no. of days.
Can somebody help here pls?
I am not clear, what are you expecting.
E.g. Review Date is 1/14/2019 and SLA is 15 days then Target date should be 2/4/2019 (which excludes weekends and holidays). Your code above will only help me to ignore the weekend/holiday within the Target Date.. but it won't calculate the Target Date per my requirement. Try doing it in excel with 'workday' formula.
I have done this in a client project that I, unfortunately, cannot share due to security concerns but here is the jist of it.
1. Find the number of days left in the week in which the request was created.
2. For the next week find the number of business days. This is done by excluding days 1 and 7 and the day number of any holidays in the week.
3. Sum up the number of days in the full weeks since the request
4. Add any partial week days for the last week leading to the SLA date.
5. Now you know the date in business days.