Convert WeekNum to "Week of XYZ"

[BLA_68]

I’m using Weeknum to get the date of several weeks in a row. IF I want to display the date of the Sunday or Monday that starts a given week, how might I do that? For example I have Weeknum(now) and Weeknum(now)+1. How can I show:

Week of May 29th
Week of June 5

Instead of “22” or “23”?

[Darren_Murphy]

To get the Date of Monday of the current week, you can use the following in a Math column:

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

You can then use the result of that in a Template column:

If you want the date of Monday next week, just adjust the Math column as follows:

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

[BLA_68]

Awesome! I had a feeling you’d have the answer. Thanks @Darren_Murphy