Count Consecutive Days while bridging over days off and holidays

The above wasn't working. When column H items were changed to DAYOFF for example the results wouldn't budge. (I thought I'd checked everything out.)

It works with this one.

=SUM(IFERROR(((C2:H2={"MIAOUT";"MIA";"UPTO"})+(-1*(C2:H2={"";"<>MIAOUT";"<>MIA";"<>UPTO"}))),FALSE))


It was the offsetting ranges causing the goof. The DAYOFF and HOLOFF were unnecessary, too.

Here's another.

=MAX(FREQUENCY(IF(C2:I2={"MIAOUT";"MIA";"UPTO"},COLUMN(C2:I2)),IF(C2:I2={"";"<>MIAOUT";"<>MIA";"<>UPTO"},COLUMN(C2:I2))))

Array entered.