Count max contiguous blank cells

Dear All
I have a working day sheet counts for employees in month.
Which formula can I use to count max contiguos absent days (blank cells) of each employee? (No use code)
Thanks.

Hi, one way is to make helping columns where contiguos blanks are (automatically) replaced by increasing numbers, and then use the max-function. The helping columns could also be placed in another sheet.

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!