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

[renecernitz]

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)

Thanks in advance

@BA_Pete

[BA_Pete · Accepted solution]

Hi @renecernitz ,

Try this in a new custom column:

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

This gives me the following ouput:

Pete

[ronrsnfld]

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.

[BA_Pete]

Hi @ronrsnfld ,

Thanks for the suggestion.

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

Pete