Alteryx Designer Desktop Discussions

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

Given two dates, calculate the number of weekend days between them (saturdays/sundays)

BS_THE_ANALYST
14 - Magnetar

Hi all!

 

I was just working on Weekly Challenge 41 when I was inspired by this particular problem. 

 

Can we write a formula where we input two dates, and it will output the number of weekend days in between them? (inclusive of both dates)

 

For example: given these two dates -  Wednesday 28th December 2022 & Saturday 14th January 2023. We can see, by manually counting, that there are 5 weekend days between them.

 

I'd love to see some different takes on tackling this question! 

 

Thanks, 

BS

 

 

 

10 REPLIES 10
linux
5 - Atom

Cool approach @DataNath thanks for sharing

Labels