cancel
Showing results for
Did you mean:
Frequent Visitor

## How to get the date of the next specific day of the week from a given date

Hi fellow members,

I need to solve th following issue:

From a given date I need to obtain the date of thursday of the following week.

 Input date Input day of week Result Result day of week 06/09/2021 monday 16/09/2021 thursday (next week) 08/10/2021 friday 14/10/2021 thursday (next week) 13/10/2021 wednesday 21/10/2021 thursday (next week) 18/10/2021 monday 28/10/2021 thursday (next week)

### @BA_Pete

1 ACCEPTED SOLUTION
Super User

Hi @renecernitz ,

Try this in a new custom column:

``Date.AddDays(Date.EndOfWeek([Input date]), 4)``

This gives me the following ouput:

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

3 REPLIES 3
Super User

Hi @renecernitz ,

Try this in a new custom column:

``Date.AddDays(Date.EndOfWeek([Input date]), 4)``

This gives me the following ouput:

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Solution Sage

Suggest you specify the `firstDayOfTheWeek` argument as `Day.Monday`.

If I don't do that, your formula returns the next Wednesday.  Possibly due to my regional settings which have Sunday as the first day of the week.

Or, better yet, ask the OP when his week starts, and adjust accordingly.

Super User

Hi @ronrsnfld ,

Thanks for the suggestion.

If the necessary correction was more difficult than changing one number then I might have done so.

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!