Find/count consecutive entries in a row in excel

Hi everyone,

I had a rather intriguing excel question for the forum.

I have a row in excel that goes like this,

1 2 3 4 5 1 2 3 2 1 2 5 1 3 2 1 4 4 3 2 5

I want to find the count of consecutive entries less than 5 and the count has to reset back to 0 if 5 is found and then start again from that 5 onwards

for example

1 2 3 4 --> gives 4
1 2 3 4 5 1 2 3 --> gives 3

1 2 3 4 5 1 2 3 2 1 2 5 1 3 2 1 4 4 3 2 5 --> gives 0

My basic idea is to find the most number of days a person has been scoring lesser than 5 and ofc it resets if he/she able to get 5 or above on a certain day. Therefore each value on a row is per day basis. (column means dates)

Help me out, Please. <3

EDIT: I also want blanks to be considered as 0.

real example: # 0.1 0.2 1 1.1 2 is the first row where '#' is blank, anything less than 1 should be counted and the first occurance of 1 or above value resets the count and counter starts again from that spot onwards, while ignoring all before it.

# # 1.1 2 --> gives 2
0.1 # 0.2 2 --> gives 3
## 0.1 1.1 0.1 --> gives 1
if no other choice then i can replace all blanks with '0' too