# Find next Friday (or find next day of week)

**URL:** <https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262>\
**Category:** Ask the Community\
**Created:** [May 5, 2021, 5:22pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262 "2021-05-05T17:22:59Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Allen\_Ormond](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/allen_ormond/32/8784_2.png) [@Allen\_Ormond](https://connect.superhuman.com/u/Allen_Ormond)\
**Post date:** [May 5, 2021, 5:22pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/1 "2021-05-05T17:22:59Z")

</div>

Is there any way to deduce the date of the next following Friday (or any day of the week) given a particular date? For example, if a column has the date “May 5th 2021” I would want another column to find the next Friday and return “May 7th 2021”.

Thanks!  
Allen

---

<div class="post-metadata">

**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\
**Post date:** [May 5, 2021, 5:40pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/2 "2021-05-05T17:40:13Z")

</div>

The formula for **Nearest Friday** would be:

```auto
YourDate + (6 - YourDate.Weekday())

```

---

<div class="post-metadata">

**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\
**Post date:** [May 5, 2021, 6:17pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/3 "2021-05-05T18:17:28Z")

</div>

…unless it’s already Saturday and it will show the previous one.

Correct one would be:

```auto
YourDate + Remainder(13 - YourDate.Weekday(), 7)

```

if it should show the same day on Friday, and

```auto
YourDate + Remainder(12 - YourDate.Weekday(), 7) + 1

```

if it should show the next one.

---

<div class="post-metadata">

**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\
**Post date:** [May 5, 2021, 6:21pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/4 "2021-05-05T18:21:01Z")

</div>

oof good catch! That would have been a bummer

---

<div class="post-metadata">

**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\
**Post date:** [May 5, 2021, 6:45pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/5 "2021-05-05T18:45:11Z")

</div>

> [@Paul\_Danyliuk](#):
>
> `YourDate + Remainder(12 - YourDate.Weekday(), 7) + 1`

Hi @Paul_Danyliuk , great catch, just some minor correction, just to get the formula right:

 ![image](https://global.discourse-cdn.com/coda1/original/3X/4/6/46941f6db4d0da8c85ecd46edcdccac2f65da394.png)

```
YourDate+Remainder(12 - YourDate.ToDateTime().Weekday(),7)+1

```

As in Remainder() we need to have the **DateTime** input 🕵️‍♂️

---

<div class="post-metadata">

**Author:** ![Allen\_Ormond](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/allen_ormond/32/8784_2.png) [@Allen\_Ormond](https://connect.superhuman.com/u/Allen_Ormond)\
**Post date:** [May 6, 2021, 6:50pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/6 "2021-05-06T18:50:25Z")

</div>

Thanks everybody! I ended up using the following:

`YourDate + Remainder(7 + 6 - YourDate.ToDateTime().Weekday(), 7)`

to find the next Friday (or the current date if it IS a Friday).

And then for the previous Friday (or the current date if it IS a Friday):

`YourDate - Remainder(7 - 6 + YourDate .Weekday(), 7 )`

In both examples the 6 can be replaced with the number of whichever day of the week you desire.

---

<div class="post-metadata">

**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\
**Post date:** [May 6, 2021, 8:25pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/7 "2021-05-06T20:25:37Z")

</div>

Thank you so much for looping back around with a summary of what worked for you! Many future searchers will benefit from that.

What do you think about changing the title of this post to, “Find next Friday (or Next Day of Week)”? That might be more easily found in forum searches 🙂

---

<div class="post-metadata">

**Author:** ![Connor\_McCormick1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/connor_mccormick1/32/24174_2.png) [@Connor\_McCormick1](https://connect.superhuman.com/u/Connor_McCormick1)\
**Post date:** [September 20, 2021, 3:04pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/8 "2021-09-20T15:04:29Z")

</div>

For me a reliable way to find the next monday | tuesday | etc is to paste in this formula and play with the Number:

```auto
Date + Remainder(7 + Number - Date.Weekday(), 7) + 1

```

Where Number is replaced with:

1. for Monday
2. for Tuesday
3. for Wednesday
4. for Thursday
5. for Friday
6. for Saturday
7. for Sunday

If instead you want it to show the current day as the “next day of week”, use this formula instead:

```auto
Date + Remainder(8 + Number - Date.Weekday(), 7)

```

The only thing we’ve changed is the 7 became an 8 and the + 1 is removed from the end.

---

<div class="post-metadata">

**Author:** ![Connor\_McCormick1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/connor_mccormick1/32/24174_2.png) [@Connor\_McCormick1](https://connect.superhuman.com/u/Connor_McCormick1)\
**Post date:** [July 24, 2022, 3:44pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/9 "2022-07-24T15:44:00Z")

</div>

@Shaina_Torgerson are you able to change the title of this post so that it’s more discoverable? Something like “Find next Friday (or find next day of week)”

---

<div class="post-metadata">

**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\
**Post date:** [July 24, 2022, 5:02pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/10 "2022-07-24T17:02:29Z")

</div>

Dear @Connor_McCormick1 ,

Maybe @Shaina_Torgerson will be able to assist you as Steph isn’t anymore a Codan

---

<div class="post-metadata">

**Author:** ![Connor\_McCormick1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/connor_mccormick1/32/24174_2.png) [@Connor\_McCormick1](https://connect.superhuman.com/u/Connor_McCormick1)\
**Post date:** [July 24, 2022, 5:36pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/11 "2022-07-24T17:36:00Z")

</div>

Ah, wasn’t aware they had left that role. Great! Hi @Shaina_Torgerson👋

(P.S. is there a @CommunityManager handle that aliases the right person? Is that possible is Discourse?)

---

<div class="post-metadata">

**Author:** ![louca.developer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/louca.developer/32/22685_2.png) [@louca.developer](https://connect.superhuman.com/u/louca.developer)\
**Post date:** [July 26, 2022, 4:23pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/12 "2022-07-26T16:23:16Z")

</div>

Using the [Recurrence Rule](https://coda.io/packs/recurrence-rule-12797) pack: `FromText("every friday").ModifyRRule(dtstart: Today()).First()`

Edit: the [Relative Dates](https://coda.io/packs/relative-dates-10292) pack is even more suitable.

---

<div class="post-metadata">

**Author:** ![Shaina\_Torgerson](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/shaina_torgerson/32/21147_2.png) [@Shaina\_Torgerson](https://connect.superhuman.com/u/Shaina_Torgerson)\
**Post date:** [July 27, 2022, 8:42pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/13 "2022-07-27T20:42:19Z")

</div>

Absolutely @Connor_McCormick1 ! I went ahead and changed the title of the post 😄 . I’m unsure if @communitymanager handle is something we can do at this time, but I will take a look. Great suggestion!

---

<div class="post-metadata">

**Author:** ![Alberto\_Delgado](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/alberto_delgado/32/37263_2.png) [@Alberto\_Delgado](https://connect.superhuman.com/u/Alberto_Delgado)\
**Post date:** [February 12, 2024, 9:18pm UTC](https://connect.superhuman.com/t/find-next-friday-or-find-next-day-of-week/23262/14 "2024-02-12T21:18:31Z")

</div>

> Using the [Recurrence Rule](https://coda.io/packs/recurrence-rule-12797) pack: `FromText("every friday").ModifyRRule(dtstart: Today()).First()`
> 
> Edit: the [Relative Dates](https://coda.io/packs/relative-dates-10292) pack is even more suitable.

I was struggling to understand the formulas here 😅

Thank you for turning on easy mode