How to add weekend and holiday dates in a 30 day interval?

Joker_Hazard

Dummy data.xlsx

Dummy Workflow.yxmd

Hi all! I am reaching out because I need help with my workflow.

In summary, I perform a daily activity to calculate the average of last 30 days. (D-1 to D-30) However, when performing this activity on monday, I need Alteryx to copy paste the results of the last day column (in this case 2026_04_10) and create two extra columns with this data 2026_04_11 and 2026_04_12.

This should only happen during the weekends and on holidays.

A holiday example:

Lets suppose 2026_04_15 is a holiday. On 2026_04_16 I will perform the automation and it should generate 2026_04_14 and copy paste the results of 04_14 on 2026_04_15.

On both examples, if Alteryx copy pasted values due to holiday or weekends, it should remove columns in the beginning to make it only 30day interval (in the aforementioned weekend example 2026_04_11 and 2026_04_12)

Is there a way to do this? I'm completely stuck. I have no issues on creating an extra table with holiday dates to use as a reference in the automation, but I cant think of a formula to do this..

Thanks

jrlindem

In short, I think you're going to need to Transpose so the data is in two columns: Date and Values.

Then, using a reference table for holidays and/or formula tool to flag those holidays and weekends… You can move on to a Multi-Row-Formula Tool to handle the logic of what you need done based on the span of days, or holidays, or weekends, etc.

To flip everything back, once done, use the Crosstab tool.

Hope that helps get you started, -Jay