# Last day of the week

**URL:** <https://community.glideapps.com/t/last-day-of-the-week/76507>\
**Category:** Ask for Help\
**Created:** [September 20, 2024, 1:33pm UTC](https://community.glideapps.com/t/last-day-of-the-week/76507 "2024-09-20T13:33:51Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [September 20, 2024, 3:13pm UTC](https://community.glideapps.com/t/last-day-of-the-week/76507/3 "2024-09-20T15:13:28Z")

</div>

I’m not a expert with dates. Actually dates confuse me because of each country’s time zone 😂

I just tried to edit this formula which @ThinhDinh shared and got a good result. ( possible with js too but afraid to write because not sure if it work with device time zone 🙂 ) Maybe the legends could confirm? (not tagging because it will be a disturbance 😉 so naming them would be Jeff, Darren, Thinh, Robert and others)

Thinh’s post : [How do I get the start date of current week? - #2 by ThinhDinh](https://community.glideapps.com/t/how-do-i-get-the-start-date-of-current-week/71488/2)

Thinh’s formula : `N-WEEKDAY(N)+2-HOUR(N)/24-MINUTE(N)/1440-SECOND(N)/86400`

Edited formula by me: `N - WEEKDAY(N) + 8 - HOUR(N)/24 - MINUTE(N)/1440 - SECOND(N)/86400`

Result :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/911cbea39b3393f9a7d25144c7cc252253795c03.png)

Thank you and have a great weekend!

---

_[View the full topic](https://community.glideapps.com/t/last-day-of-the-week/76507)._