Finding Previous or next Monday based on Condition from a date

[VahidGoli]

Hi All,

I have a date, say "2021-06-09", I need a formula or a tool to get the next Monday "2021-06-14", or the previous Monday "2021-06-07", based on the condition.

I know how to do the condition, but I don't know how to achieve the Monday calculation in Alteryx.

Would you please guide me on that?

Thank you in advance.

[apathetichell · Accepted solution]

Is your date currently set up as a date?  If so - see the attached workflow which uses some nifty date/time tricks.

[VahidGoli]

Hi @apathetichell , you are a legend mate. Thanks.

[MackStewart]

This is awesome. changed -1 to -0 to get Sunday - just realised that -0 is redundant. :D