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 |
Solved! Go to Solution.