Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Add 7 working days to a date column without end date

Ultralightbeam
8 - Asteroid

Hey guys I have a column called ReportDate and want to add 7 working days to that date.

So If ReportDate = 2022-07-21 + 7 days = 2022-07-29, I am seeing generating dates with end dates.

 

Thank you for your help

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Ultralightbeam 
I would just add 10 or 11 days, then filter out the Week ends.

0721-Ultralightbeam.PNG

grazitti_sapna
17 - Castor

@Ultralightbeam, give this a try.

grazitti_sapna_0-1658376673636.png

 

Thanks!

Sapna Gupta
binuacs
21 - Polaris

@Ultralightbeam Another way of doing this, similar to @Qiu approach

binuacs_0-1658381951672.png

 

Labels
Top Solution Authors