Hi Folks
Need your help to getting below OutputDate
Id | Date1 | Date2 | Date3 | OutputDate |
100 | 3/10/2021 | 3/15/2021 | 3/24/2021 | |
100 | 3/10/2021 | 3/14/2021 | 3/20/2021 | |
100 | 3/10/2021 | 3/13/2021 | 3/19/2021 | |
100 | 3/10/2021 | 3/12/2021 | 3/19/2021 | 3/19/2021 |
100 | 3/10/2021 | 3/11/2021 | 3/19/2021 | |
200 | 2/1/2021 | 3/2/2021 | 3/31/2021 | |
200 | 2/1/2021 | 3/1/2021 | 3/10/2021 | |
200 | 2/1/2021 | 3/1/2021 | 3/1/2021 | |
200 | 2/1/2021 | 2/28/2021 | 2/28/2021 | |
200 | 2/1/2021 | 2/22/2021 | 2/27/2021 | |
200 | 2/1/2021 | 2/15/2021 | 2/26/2021 | 2/26/2021 |
1. Case Id 100 : Calculate Date1 + 2Business Days and check Date2 and Resultant get corresponding date3
2. Case Id 200 : Same as above but here 2/1/2021 + 2BD = 2/3/2021 and Date2 this date is not present so look the nearest on first.