Change work week to Friday through Thursday

[becksintex]

I am creating a case tracker for social workers to track when their reviews are due. Reviews are done every Thursday, so if my tracker says its due next Monday, it actually needs to be completed this Thrusday, or it will be overdue on Monday. I have a formula that calculates all the dates depending on the IDC date and whether it is 30 or 90 days between reviews. Then I highlight the dates with conditional formatting so things due next week are yellow and things due this week are red.

However, so they don't have to look at the actual dates to see if they need to move the review date up, I wanted to change the start date of the week to Friday, so this week would highlight this Friday to next Thursday, and next week would highlight the next Friday to the following Thursday.

I'm hoping I can do this in the toolbar but if I need to use formulas, would you tell me where to put the formula, and if I need to layer it over the formulas in the date cells, can you tell me how to do that?

Thanks in advance!

[Fluff13]

You can change the formula so all dates will be a Thursday.
In D4 copied down

Please Login or Register  to view this content.

[becksintex]

Thats helpful, thank you!
Is there a way to make sure they are going to the correct Thursday? They all need to be before the actual due date... should I make the formula 28 days or 84 days? Multiples of 7...That would eventually throw the ACTUAL review days off I think

[Fluff13]

They all need to be before the actual due date

They will be before the due date, unless the due date is a Thursday.

[becksintex]

Thats very helpful, thank you!

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.