I take it that "Yes" means the person worked, and "No" means they didn't? Let's call that column [Worked].
I recommend using a multi row formula tool to create a ticker that starts with 1 on the first day worked, increases by 1 for every subsequent day worked, and resets back to 1 next time the person works after having taking some time off.
In the configuration of the Multi Row Formula tool, create a new field called Ticker. Set Value for Rows that Don't Exist to 0 or Empty. If you have multiple employees (more than just employee #1111), then Group By Employee.
The formula will look something like this:
if([Date]="No")
then 0
elseif(Row:[Worked]="Yes" and (Row-1:[Worked]="No" or Row-1:[Worked]=0))
then 1
elseif(Row-1:[Worked]="Yes")
then Row-1:[Ticker]+1
else Null()
endif
You may have to play with the formula a bit, but that's the general idea.
Then you can filter for [Ticker]>=7, and those will be the dates where the employee is on their 7th (or 8th or 9th, etc.) day of working.
