Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

business days

ntudev
8 - Asteroid

I need a formula that will give me 5 business days prior to today. Any ideas? So if today is Monday June 20th, i would like a new column that just says June 13th.

3 REPLIES 3
Luke_C
17 - Castor

Hi @ntudev 

 

Here's one way: Create a record for the prior week from each date, filter out weekends, and take the earliest remaining date.

 

This is a very common ask, so definitely search around the community for more approaches and ways to add handling for holidays, etc.

 

Luke_C_0-1655996892303.png

 

 

HomesickSurfer
12 - Quasar

Hi @ntudev 

 

You may benefit from calculating each of the past 5 business days and excluding observed holiday dates...filter to x- date you desire.

Hope you like it.  Workflow attached.

 

HomesickSurfer_0-1655998441134.png

 

Hi @ntudev 

 

I used a formula tool to get what you are looking for. I love Generate row tool used by @Luke_C  and love the forward thinking of @HomesickSurfer . You have all options.

christine_assaad_0-1655999742606.png

 

Labels