# Filter By Week

**URL:** <https://community.glideapps.com/t/filter-by-week/13957>\
**Category:** Feature Requests\
**Created:** [August 13, 2020, 6:31pm UTC](https://community.glideapps.com/t/filter-by-week/13957 "2020-08-13T18:31:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lizzie\_Marine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lizzie_marine/32/11954_2.png) [@Lizzie\_Marine](https://community.glideapps.com/u/Lizzie_Marine)\
**Post date:** [August 13, 2020, 6:31pm UTC](https://community.glideapps.com/t/filter-by-week/13957/1 "2020-08-13T18:31:34Z")

</div>

Hello, I have a tab called Events and I was wondering if it was possible to filter it by weeks. I want it to only show events in the current week. Help would be much appreciated. Thank You

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 13, 2020, 6:33pm UTC](https://community.glideapps.com/t/filter-by-week/13957/2 "2020-08-13T18:33:36Z")

</div>

Do you want to list upcoming events in the next 7 days (rolling)?  
Or do you want to show events from the week even if the days are in the past?

The right solution will depend on what you want to show.

---

<div class="post-metadata">

**Author:** ![adelhammoud](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adelhammoud/32/5587_2.png) [@adelhammoud](https://community.glideapps.com/u/adelhammoud)\
**Post date:** [August 13, 2020, 6:43pm UTC](https://community.glideapps.com/t/filter-by-week/13957/3 "2020-08-13T18:43:09Z")

</div>

If to be done from Google Sheets,

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ed2e8e169cbbbb77dc10d356d8e0bb3610217f55.png)

Formula in C2: =ARRAYFORMULA(if(A2:A\<\>"",weeknum(B2:B,1),""))

Formula in D2: =ARRAYFORMULA(if(A2:A\<\>"",if(weeknum(today(),1)=weeknum(B2:B,1),TRUE,FALSE),""))

So in Glide, display what Show=TRUE

Now, getting this done from GDE, you need to calculate Week-number using math column and then compare it with today’s date - longer trip in my opinion.

---

<div class="post-metadata">

**Author:** ![Lizzie\_Marine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lizzie_marine/32/11954_2.png) [@Lizzie\_Marine](https://community.glideapps.com/u/Lizzie_Marine)\
**Post date:** [August 13, 2020, 7:12pm UTC](https://community.glideapps.com/t/filter-by-week/13957/4 "2020-08-13T19:12:30Z")

</div>

I want to list upcoming events in the next 7 days (rolling)

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 13, 2020, 7:27pm UTC](https://community.glideapps.com/t/filter-by-week/13957/5 "2020-08-13T19:27:53Z")

</div>

Create an additional column in your Google Sheet which spits out TODAY()+7 using an array formula.  
In the Builder, filter for events where the event date is less than TODAY()+7.

---

<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:** [March 27, 2024, 10:12am UTC](https://community.glideapps.com/t/filter-by-week/13957/6 "2024-03-27T10:12:46Z")

</div>