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.
Thanks in advance
Go to Solution.
Hi @renecernitz ,
Try this in a new custom column:
Date.AddDays(Date.EndOfWeek([Input date]), 4)
This gives me the following ouput:
Proud to be a Datanaut!
View solution in original post
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.
Hi @ronrsnfld ,
Thanks for the suggestion.
If the necessary correction was more difficult than changing one number then I might have done so.
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.