Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
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