Cell to return value if 6th & 7th Consecutive Day

[smithers0787]

Good evening all,

I hope someone more experienced with excel can help me.
I work at a logistics company and the rota we are using i need it to flag up when it is there 6th and 7th day consecutively working due to rules in the depot , at the moment we manually check and as we are expanding i need something more robust

However i would like the formula to be hidden so we do not remove the formulas from the cells when we write in them (so it always is updating with changes)

i have inputted a screenshot of our rota and showing where i want it to show 6th and 7th day
if anybody has a formula for this that would be great.

Thank You
Nick

Moderator note:
Image removed by FlameRetired. There appeared to contain personal (real) names and phone numbers in the screenshot --- which I missed earlier.
Please do not post sensitive information in the future.

Thanks to José Augusto for spotting that and mentioning it.

[FlameRetired]

1.) Please update your profile. "new" doesn't tell us much (2016 desktop? 365 subscription?) and in a couple of years will mean (?)

2.) Please upload an Excel workbook representative of the challenge. Pictures/screenshots are rarely of any use.

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

[José Augusto]

...
be sure to desensitize the data
...

Hi Dave

I suppose the image in OP post must be removed, due to expose names and mobile numbers
Regards

[FlameRetired]

Good catch José!!!