# Every Sunday

**URL:** <https://community.glideapps.com/t/every-sunday/26536>\
**Category:** Ask for Help\
**Created:** [May 7, 2021, 7:42pm UTC](https://community.glideapps.com/t/every-sunday/26536 "2021-05-07T19:42:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tombaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tombaker/32/25878_2.png) [@Tombaker](https://community.glideapps.com/u/Tombaker)\
**Post date:** [May 7, 2021, 7:42pm UTC](https://community.glideapps.com/t/every-sunday/26536/1 "2021-05-07T19:42:56Z")

</div>

This may be a simple question and if it is please forgive me! I’m trying to build an app that helps with rotas at church each Sunday such as welcoming, coffee etc…

Is there a formula I could use to automatically call up the dates for Sundays for the next year?

---

<div class="post-metadata">

**Author:** ![Tombaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tombaker/32/25878_2.png) [@Tombaker](https://community.glideapps.com/u/Tombaker)\
**Post date:** [May 7, 2021, 11:11pm UTC](https://community.glideapps.com/t/every-sunday/26536/2 "2021-05-07T23:11:06Z")

</div>

So I have done some playing around and here is what I’ve done. I’m using glide tables for the app but I opened a Google sheet and began to manually type out the date for every Sunday, then after 5 or so I dragged down and filled a couple of years worth of Sunday dates.

I then used =TEXT(B3, “dddd”) to check they were all Sunday. And then =TEXT(B3, “mmmm”) to grab the month as well.

So now I’m going to copy and paste into my glide table.

It’s got the result I need for my app, but was it the easiest way?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 7, 2021, 11:28pm UTC](https://community.glideapps.com/t/every-sunday/26536/3 "2021-05-07T23:28:41Z")

</div>

Use arrayformula starting sunday date =ARRAYFORMULA(text((row(A1:A)\*7+VALUE(“05/10/2020”)-7),“ddd mm/dd/yyyy”))  
if you place this formula in second row than use:  
=ARRAYFORMULA(text((row(A2:A)\*7+VALUE(“05/10/2020”)-14),“ddd mm/dd/yyyy”))

---

<div class="post-metadata">

**Author:** ![Tombaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tombaker/32/25878_2.png) [@Tombaker](https://community.glideapps.com/u/Tombaker)\
**Post date:** [May 8, 2021, 6:08am UTC](https://community.glideapps.com/t/every-sunday/26536/4 "2021-05-08T06:08:17Z")

</div>

Thank you, I’ll give that a try

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/every-sunday/26536/5 "2024-01-17T16:52:21Z")

</div>