Date Range on workflows

[Myusrename001]

Hello Experts,

Needed to implement below logic in alteryx to determine the values based on the date range.

Let me know if any clarificaiton.  

Value date	Deposits to Be made	Comment
1st to 7th	8th	If 8th falls on SAT or SUN then it would be subsequent business day
8th to 15th	16th	If 16th falls on SAT or SUN then it would be subsequent business day
16th to 22nd	23rd	If 23rd falls on SAT or SUN then it would be subsequent business day
23rd till end of the month	1st of next month	If 1st falls on SAT or SUN then it would be subsequent business day

[Peachyco · Accepted solution]

Something like this, maybe:

Notice that for the first record, the [Deposit Date] is on the 9th. That's because 08 Jan 2023 is a Sunday.

 

[Myusrename001]

Perfect - Thanks so much for your help !