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
binu_acs
21 - Polaris

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

binuacs_0-1658381951672.png

 

Labels
Top Solution Authors