Week Start and End on specific days/dates

[MadeInHB]

So I have a large set of data for the year.  It tracks items completed each day.  However, weeks aren't calculated by calendar weeks.  We have a Thursday to Wednesday week.  So, I am trying to create a Week Beginning and Week Ending for every item completed.

Example

Completed Date	Week Beginning	Week Ending
7/1/2019	6/27/2019	7/3/2019
7/9/2019	7/4/2019	7/10/2019
7/12/2019	7/11/2019	7/18/2019
7/22/2019	7/18/2019	7/25/2019

Was wondering if anyone has an formulas or easier way to get these dates from the Completed Date.

Thanks.

[lmorrell]

Hi @MadeInHB, 

One possible solution would be to calculate the day of the week, and then add and subtract days accordingly. I have done this in the attached workflow.

However, I couldn't help but notice for completed dates 7/1/2019 and 7/9/2019 the week endings are a Wednesday - whereas for completed dates 7/12/2019 and 7/22/2019 the week endings are Thursdays. Is there more information to compute these Week Endings? 

[Inactive User · Accepted solution]

Solution Attached.

[MadeInHB]

Wow, that looked easier than I was making it.  Thanks!!

[JonServiceNow]

I used the solution above from the Inactive User. To adjust for week beginning on Sunday just delete the adjust start date and it works perfect