Hi Team,
I have following Dataset
logic for expected output is
IF FILE DATE = DATES then it is Today
file date + 1 (except sun , sat, holidays) = dates then today +1
as shown in the example 4/26 and 4/30 is considered as today +1 , since 29th is holiday it should consider next working day
same logic for T-1 and T-2 also
| File Date | Dates |
| 4/26/2024 | 4/26/2024 |
| 4/26/2024 | 4/26/2024 |
| 4/26/2024 | 4/30/2024 |
| 4/26/2024 | 4/30/2024 |
| 4/26/2024 | 4/25/2024 |
| 4/26/2024 | 4/25/2024 |
| 4/26/2024 | 4/23/2024 |
| 4/26/2024 | 4/23/2024 |
| 4/26/2024 | 4/26/2024 |
Expected Output:
| File Date | Dates | Summary |
| 4/26/2024 | 4/26/2024 | Today |
| 4/26/2024 | 4/26/2024 | Today |
| 4/26/2024 | 4/30/2024 | Today + 1 |
| 4/26/2024 | 4/30/2024 | Today + 1 |
| 4/26/2024 | 4/25/2024 | Today - 1 |
| 4/26/2024 | 4/25/2024 | Today - 1 |
| 4/26/2024 | 4/23/2024 | Today - 2 |
| 4/26/2024 | 4/23/2024 | Today - 2 |
| 4/26/2024 | 4/26/2024 | Today |
| Holidays |
| 4/29/2024 |
| 4/24/2024 |
