How to count the five consecutive 'x' value within the 10 horizontal cells

[luck99]

Hello everyone,

I need assistance with an Excel problem.

I would like to count the occurrences of 5 consecutive 'x' values within a horizontal range of 10 cells, such as from A1 to J1.

Your help with this Excel issue would be greatly appreciated.

Thank you.

 

[luck99]

Good day, I try the solution but unfortunately it is not working to excel 2016 version.
Thank you

 

[bebo021999]

In practice, there are cases of absence from the end of this month extending into the beginning of the next month, for example: May 30 & 31 and June 1, 2, 3.

In such cases, would it be counted as 5 consecutive days?