Hi All, Please help me to build the below logic
EDate:-
If Today is Monday then EDate Include(Today-3,Today,Today+1) - Friday,Sunday,Suturday,Monday and Tuesday for EDate Report.
If Today is Friday then EDate Include(Today-1,Today,Today+2)- Thurday,Friday,Suturday and Sunday, Monday for EDate Report.
If Today is Tuesday Then EDate Include(Today-1,Today,Today+1) - Monday, Thesday, Wednesday for EDateReport.
PDate:-
If Today is Monday then PDate Report is (Today+2) Wednesday.
If Today is Friday then PDate Report is Exclude(Suturday and Sunday) is (Today+2) Tuesday.
| RunDate | EDate | PDate | ExpectedOutput |
| 3/3/2023 | 3/3/2023 | 3/22/2023 | EDate Report |
| 3/3/2023 | 3/3/2023 | 4/5/2023 | EDate Report |
| 3/3/2023 | 2/23/2023 | 3/7/2023 | PDate Report |
| 3/3/2023 | 3/3/2023 | 4/3/2023 | EDate Report |
| 3/3/2023 | 3/4/2023 | 4/11/2023 | EDate Report |
| 3/3/2023 | 3/5/2023 | 4/4/2023 | EDate Report |
| 3/3/2023 | 3/6/2023 | 4/20/2023 | EDate Report |
| 3/3/2023 | 3/3/2023 | 3/30/2023 | EDate Report |
| 3/3/2023 | 2/20/2023 | 3/7/2023 | PDate Report |
| | | | |
| 3/6/2023 | 3/3/2023 | 3/30/2023 | EDate Report |
| 3/6/2023 | 3/4/2023 | 3/31/2023 | EDate Report |
| 3/6/2023 | 3/6/2023 | 3/21/2023 | EDate Report |
| 3/6/2023 | 2/17/2023 | 3/8/2023 | PDate Report |
| 3/6/2023 | 3/6/2023 | 4/14/2023 | EDate Report |
| 3/6/2023 | 3/6/2023 | 3/28/2023 | EDate Report |
| 3/6/2023 | 2/21/2023 | 3/8/2023 | PDate Report |
| 3/6/2023 | 3/5/2023 | 3/22/2023 | EDate Report |
