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 DateWeek BeginningWeek Ending7/1/20196/27/20197/3/20197/9/20197/4/20197/10/20197/12/20197/11/20197/18/20197/22/20197/18/20197/25/2019 Was wondering if anyone has an formulas or easier way to get these dates from the Completed Date. Thanks.

Week Start and End on specific days/dates

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.

Reporting

Date Time

Data Investigation

Accepted answers

unknown

Solution Attached.

Solution.yxmd

All comments

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?

Week Start and End on Specific daysdates.yxmd

unknown

Solution Attached.

Solution.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703