Count between Two Cells

[fareedexcel]

Dear Experts,

I require to check the count interval between the 1st OFF to the Last OFF. After the Last OFF, count should not happen. Expected result attached for your reference.

								Tue	Wed	Thur	Fri	Sat	Sun	Mon	Tue	Wed	Thur	Fri	Sat	Sun	Mon	Tue	Wed	Thur	Fri	Sat	Sun	Mon	Tue	Wed	Thur	Fri	Sat	Sun	Mon	Tue	Wed	Thur
STAFF NO.	NAME	NORMAL DAYS	SL(Full)	SL(Half)	SL(Nill)	OVERTIME (Off Days)	OVERTIME (Hours)	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	INTERVAL	EXPECTED RESULT
1	David	31.0	0	0	0	0	15.00	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-		5-5-5
2	Cameroon	31.0	0	0	0	1	38.00	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-		5-5-5
3	Sachin	31.0	0	0	0	1	11.50	-	-	-	-	OFF	OFF	-	-	-	-	-	-	OFF	OFF	-	-	-	-	-	-	OFF	OFF	-	-	-	-	-	-	OFF	OFF	-		6-6-6
4	Tendulkar	27.0	0	0	0	0		-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-		5-5-5
5	Rahul	30.0	1	0	0	0		OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	-	-	-	-	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-		5-5-4-5
6	Dravid	31.0	0	0	0	0		-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-		5-5-5
7	Narain	20.0	0	0	0	0		-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	-	-	-	-	-	-	-		5-5
8	Karthik	31.0	0	0	0	0		-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	-		5-5-5
9	Dhoni	31.0	0	0	0	0		-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	OFF	OFF	-		5-5-5-4
10	Singh	12.0	0	0	0	0	8.75	-	-	-	OFF	OFF	-	-	-	-	-	OFF	OFF	-	-	-	-	OFF	-	-	-	-	-	-	-	-	-	-	OFF	-	-	-		5-4-10

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col span="5"><col><col><col><col></colgroup><tbody>
</tbody>

Regards,
Fareed