Date Cal

[BRRLL99]

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

[ed_hayter · Accepted solution]

Might be a better way but I went with splitting the flow and generating rows for the missing days then remove holidays and weekends. Consolidate into a single row counting the days and then use the count of days to get the summary column