# How to round date to specific weekday?

**URL:** <https://community.glideapps.com/t/how-to-round-date-to-specific-weekday/49564>\
**Category:** Ask for Help\
**Created:** [September 18, 2022, 6:20am UTC](https://community.glideapps.com/t/how-to-round-date-to-specific-weekday/49564 "2022-09-18T06:20:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robin\_Parkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robin_parkin/32/44913_2.png) [@Robin\_Parkin](https://community.glideapps.com/u/Robin_Parkin)\
**Post date:** [September 18, 2022, 6:20am UTC](https://community.glideapps.com/t/how-to-round-date-to-specific-weekday/49564/1 "2022-09-18T06:20:51Z")

</div>

Would anyone have a suggestion for setting up a math field that calculates the next Sunday after another given date field?

We’re trying to ensure that our users receive an in-app prompt to update their availability every Sunday (which we’re doing with tabs/visibility settings). Here’s how we picture it working:

- User 1 updates their availability on Monday 19 September 2022, automatically setting ‘Availability updated’ date field to that day. ‘Availability prompt date’ math field is then automatically set for the following Sunday, 25 September, which triggers the scheduled reminder to check their availability.
- User 2 updates their availability on Wednesday 21 September 2022, automatically setting ‘Availability updated’ date field to that day. ‘Availability prompt date’ math field is still automatically set for the following Sunday, 25 September so they receive the reminder on the same day.

Any guidance much appreciated!

---

<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:** [September 18, 2022, 6:42am UTC](https://community.glideapps.com/t/how-to-round-date-to-specific-weekday/49564/2 "2022-09-18T06:42:25Z")

</div>

`Date - Weekday(Date) + 8`

 ![Screen Shot 2022-09-18 at 2.41.52 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c5d169ac2ccb14cb791fd08dc1d3d63fa6563116.png)

---

<div class="post-metadata">

**Author:** ![Robin\_Parkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robin_parkin/32/44913_2.png) [@Robin\_Parkin](https://community.glideapps.com/u/Robin_Parkin)\
**Post date:** [September 18, 2022, 7:35am UTC](https://community.glideapps.com/t/how-to-round-date-to-specific-weekday/49564/3 "2022-09-18T07:35:34Z")

</div>

Darren, you are an angel from heaven. Thank you so much!!

---

<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:** [September 19, 2022, 7:36am UTC](https://community.glideapps.com/t/how-to-round-date-to-specific-weekday/49564/4 "2022-09-19T07:36:08Z")

</div>

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