How do I get this week Monday date?

1

I would like to get this week Monday’s & Saturday’s date
how do I get with computed?
Thanks :slight_smile:

2

To get Monday this week:

Now+MOD(8-WEEKDAY(Now),7)-6

To get Saturday this week:

Now+MOD(8-WEEKDAY(Now),7)-1

CleanShot 2023-05-18 at 14.46.29@2x

CleanShot 2023-05-18 at 14.48.05@2x
CleanShot 2023-05-18 at 14.48.05@2x554×654 25.7 KB

5 Likes
3

Thanks a lot @Darren_Murphy

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.