# 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:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\
**Post date:** [September 20, 2024, 1:33pm UTC](https://community.glideapps.com/t/last-day-of-the-week/76507/1 "2024-09-20T13:33:51Z")

</div>

i have a column with some random dates, for example today date 20/09/2024.  
I need another column to show the last day of the week for 20/09/2024. I’ve tried different math formulas but didn’t work. Thank you

Kind regards

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 20, 2024, 3:01pm UTC](https://community.glideapps.com/t/last-day-of-the-week/76507/2 "2024-09-20T15:01:42Z")

</div>

Do you consider Saturday or Sunday the end of the week?

---

<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!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 20, 2024, 3:30pm UTC](https://community.glideapps.com/t/last-day-of-the-week/76507/4 "2024-09-20T15:30:58Z")

</div>

I don’t think the hour minute second stuff is necessary in this case, but otherwise the rest of it would make sense. Just depends on what’s considered the end of the week. For me it’s Saturday, but for others it’s Sunday.

---

<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 27, 2024, 3:31pm UTC](https://community.glideapps.com/t/last-day-of-the-week/76507/5 "2024-09-27T15:31:57Z")

</div>

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