# Convert WeekNum to "Week of XYZ"

**URL:** <https://community.glideapps.com/t/convert-weeknum-to-week-of-xyz/62372>\
**Category:** Ask for Help\
**Created:** [June 2, 2023, 3:20am UTC](https://community.glideapps.com/t/convert-weeknum-to-week-of-xyz/62372 "2023-06-02T03:20:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![BLA\_68](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@BLA\_68](https://community.glideapps.com/u/BLA_68)\
**Post date:** [June 2, 2023, 3:20am UTC](https://community.glideapps.com/t/convert-weeknum-to-week-of-xyz/62372/1 "2023-06-02T03:20:13Z")

</div>

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”?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 2, 2023, 3:33am UTC](https://community.glideapps.com/t/convert-weeknum-to-week-of-xyz/62372/2 "2023-06-02T03:33:12Z")

</div>

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

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

```

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

![CleanShot 2023-06-02 at 11.30.10@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc5fb594e6003f65c1c1bbf3d23b75aa2b68665f.png)

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

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

```

---

<div class="post-metadata">

**Author:** ![BLA\_68](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@BLA\_68](https://community.glideapps.com/u/BLA_68)\
**Post date:** [June 2, 2023, 3:51pm UTC](https://community.glideapps.com/t/convert-weeknum-to-week-of-xyz/62372/3 "2023-06-02T15:51:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 3, 2023, 3:52pm UTC](https://community.glideapps.com/t/convert-weeknum-to-week-of-xyz/62372/4 "2023-06-03T15:52:55Z")

</div>

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