Highlighting cells based on week dates

[DEPEWMCDOG]

The provided conditional formatting macro in Excel 2016 "Dates occurring "This Week"", assumes that the week begins on Sunday. I wish my weeks to begin on Monday when utilizing this and similar conditional formatting formulas (Last week, Next week, etc.). How do I get the formulas to recognize Monday rather than Sunday as the first day of the week?

[63falcondude]

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"