Working Date + Holiday date

[AshishAgarwal]

Hi Team,

I want to get dates for Working  + Holiday dates.

I have list of Japan holidays which I can provide as input file.

So I want Alteryx to identify below working date:

1. Working date before Japan Holiday / weekends and Japan Holiday dates.

2. Working date after Japan Holiday and weekends

Sceanrio	Holiday	Result
1	Monday	Friday + Monday
2	Monday + Tuesday	Friday + Monday + Tuesday
3	Friday	Thursday + Friday
4	Thursday + Friday	Wednesday + Thursday + Friday
5	Monday + Tuesday + Wednesday	Friday + Monday + Tuesday + Wednesday
6	Wednesday + Thursday + Friday	Tuesday + Wednesday + Thursday + Friday
7	Tuesday	Monday + Tuesday
8	Wednesday	Tuesday + Wednesday
9	Friday + Monday	Thursday + Friday + Monday
10	Sunday	Friday
11	Saturday	Friday
12	Monday & Wednesday	Tuesday + Wednesday
13	Friday & Tuesday	Monday + Tuesday

I dont want to use Python in Alteryx.

Hence is it possible to derive such behavior using different tools?

Regards,

Ashish

[Yoshiro_Fujimori]

@AshishAgarwal 

Could you show us a sample input / output data to understand your requirement?

[KGT]

Take a look at the attached.

From a list of the dates for the year with the PH attached (Generate Rows), cut the Saturday/Sunday with a DateTime Formula (DateTimeFormat([Date],"%A")) and filter, then multi-row to tag the row before and after.

[aatalai]

@AshishAgarwal this blog might help

[dreldrel]

Maybe you could use a download tool to get Japan holiday from a public api, then use the date time function in the formula tool to calculate
https://holidayapi.com/countries/jp-13/2025