Counting Maximum Consecutive Days

If the data is disposed in rows, change ROW to COLUMN.

EDIT:

      ----GC---- --GD--- ----------------------------------------GE----------------------------------------
  1   Max Consec Formula                                                                                   
  2        34.00   34.00 GD2: {=MAX(FREQUENCY(IF(E2:GC2>0, COLUMN(E2:GC2)), IF(E2:GC2=0, COLUMN(E2:GC2))))}
  3        27.00   27.00