Count max contiguous blank cells

Originally Posted by Haseeb A

In M2 withCTRL+SHIFT+ENTER,rather than just ENTER.
=MAX(FREQUENCY(IF(B2:L2="",COLUMN(B2:L2)-COLUMN(B2)+1),IF(B2:L2<>"",COLUMN(B2:L2)-COLUMN(B2)+1)))
Copy down.

It works well, thanks a lot!