Finding Previous or next Monday based on Condition from a date

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.

Date Time

Accepted answers

apathetichell

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

monday monday.yxmd

All comments

apathetichell

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

monday monday.yxmd

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.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703