Now the GAP Days formula what I’ve used is countblank(Range from 1 to 5) and GAP Status formula used is IF(countblank(5) is 1 trail gap will be shown.
I did not found any formula in the attached workbook ... except in dates in row 1.
For your query.. suggest you to go for defining names in Excel. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>