# Time Booking Application

**URL:** <https://community.glideapps.com/t/time-booking-application/71400>\
**Category:** Ask for Help\
**Created:** [March 4, 2024, 4:31pm UTC](https://community.glideapps.com/t/time-booking-application/71400 "2024-03-04T16:31:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikeMacmarts](https://avatars.discourse-cdn.com/v4/letter/m/a4c791/32.png) [@MikeMacmarts](https://community.glideapps.com/u/MikeMacmarts)\
**Post date:** [March 4, 2024, 4:31pm UTC](https://community.glideapps.com/t/time-booking-application/71400/1 "2024-03-04T16:31:11Z")

</div>

Hi there,

I’m wondering if there is a solution to allow me to calculate the start of the week date (Monday) if I’ve been given the Year and Week Number ?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 4, 2024, 4:50pm UTC](https://community.glideapps.com/t/time-booking-application/71400/2 "2024-03-04T16:50:54Z")

</div>

`date+mod(8-weekday(date),7)-6`

The above works given a date of your choosing. Not sure how to coerce it to calculate based on weeknum.

---

<div class="post-metadata">

**Author:** ![MikeMacmarts](https://avatars.discourse-cdn.com/v4/letter/m/a4c791/32.png) [@MikeMacmarts](https://community.glideapps.com/u/MikeMacmarts)\
**Post date:** [March 4, 2024, 6:45pm UTC](https://community.glideapps.com/t/time-booking-application/71400/3 "2024-03-04T18:45:54Z")

</div>

> [@Robert\_Petitto](#):
>
> date+mod(8-weekday(date),7)-6

Worked a dream thanks Robert

---

<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:** [March 11, 2024, 6:46pm UTC](https://community.glideapps.com/t/time-booking-application/71400/4 "2024-03-11T18:46:45Z")

</div>

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