# Request for help - determine Date for "next Monday"

**URL:** <https://community.glideapps.com/t/request-for-help-determine-date-for-next-monday/81302>\
**Category:** Ask for Help\
**Created:** [April 12, 2025, 2:03pm UTC](https://community.glideapps.com/t/request-for-help-determine-date-for-next-monday/81302 "2025-04-12T14:03:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [April 12, 2025, 2:03pm UTC](https://community.glideapps.com/t/request-for-help-determine-date-for-next-monday/81302/1 "2025-04-12T14:03:06Z")

</div>

I’m trying to display a date for the next Monday when given a WeekNumber.

For example, week number = 15. The next Monday is April 14, 2025. How can I do this dynamically so that the next Monday date is determined automatically when the week number changes? I guess I also need to take into account the year (which should be the current year). I think I may need to use Javascript for this, but it would be great if a fancy Math formula could do this (somehow!).

Any assistance is very much appreciated!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 12, 2025, 3:14pm UTC](https://community.glideapps.com/t/request-for-help-determine-date-for-next-monday/81302/2 "2025-04-12T15:14:00Z")

</div>

![CleanShot 2025-04-12 at 22.12.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e1bc4a5bb9dac02061c5384a630ee4c20aa876ba.png)

A test with 1st January of years that falls into Monday through Sunday, because my formula revolves around what weekday 1st January is.

 ![CleanShot 2025-04-12 at 22.13.37](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3417691037b6f30ece8969aa215fdf032ab27d8.png)

A test with weeknums from the current year.

```auto
(N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)+SIGN(WEEKDAY(N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)-1)*9+(1-SIGN(WEEKDAY(N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)-1))*2-WEEKDAY(N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)+7*(W+1-WEEKNUM((N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)+SIGN(WEEKDAY(N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)-1)*9+(1-SIGN(WEEKDAY(N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)-1))*2-WEEKDAY(N-MONTH(N)*365.25/12-DAY(N-MONTH(N)*365.25/12)+32)))

```

With N being “Now”, W being the weeknum (15 in your example).

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 12, 2025, 3:32pm UTC](https://community.glideapps.com/t/request-for-help-determine-date-for-next-monday/81302/3 "2025-04-12T15:32:22Z")

</div>

The formula:

- Tries to move your day to the approximate same day back in December of last year.
- Then, move back to 30th November of last year.
- Add 32 to make 1st January of current year.
- Add 1 to 1st January if 1st January is Sunday, else add (9 - weekday of 1st January) =\> 7 if Monday, 6 if Tuesday etc.
- At that point, we have the next Monday after January 1st. The target week is input week + 1. We add the number of weeks left until that day and get the solution.

To be honest, the math formula is super complex and I have only tested it with some cases I can think of.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [April 12, 2025, 4:45pm UTC](https://community.glideapps.com/t/request-for-help-determine-date-for-next-monday/81302/4 "2025-04-12T16:45:30Z")

</div>

Wow that formula is wild, and works! Insane! Thank you!

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [April 19, 2025, 4:45pm UTC](https://community.glideapps.com/t/request-for-help-determine-date-for-next-monday/81302/5 "2025-04-19T16:45:51Z")

</div>

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