# Fun with Dates

**URL:** <https://community.glideapps.com/t/fun-with-dates/21684>\
**Category:** Project Showcase\
**Created:** [January 24, 2021, 8:25pm UTC](https://community.glideapps.com/t/fun-with-dates/21684 "2021-01-24T20:25:08Z")\
**Posts on this page:** 1\
**Showing post:** 123

<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:** [June 3, 2021, 3:44am UTC](https://community.glideapps.com/t/fun-with-dates/21684/123 "2021-06-03T03:44:47Z")

</div>

I hope people would find this useful, I had a use case that needs users to submit a form once per week.

Showing the week number to the admin might not be the most informative, so I used these to derive the start date and end date of each week (Monday and Sunday).

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/564291925efd62b11c186dbbe0555c1afcb254ff.png)

Start date: Idea was moving everything to the current Sunday, then move back 6 days.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/76911e7f402a05f3e0c476c4245fbca6d0c39c46.png)

End date: Same as above, but just move everything to the currrent Sunday.

Weekday column was a simple weekday formula in a math column, taking from the timestamp.

Had to go for this since the default weekday start is Sunday (numbered 1).

Edited to fix an error in the start date.

---

_[View the full topic](https://community.glideapps.com/t/fun-with-dates/21684)._