We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

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