Counting Max consecutive days worked

[MDuff]

Hi I have a list of Days worked what I need a formula that will tell me how many max days they worked without having a day off So only courting the 1 on the example before 1 is a day worked blank is a day off.

Please see sheet layout below

Thanks in advance

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M
5	Mon	Tue	Thr	Fri	Sat	Sun	Mon	Tue	Thr	Fri	Sat	Sun
6	1	1	1	1			1	1		1	1	1
7	1	1	1	1			1	1	1		1
8	1	1	1	1			1	1		1	1	1
9	1	1	1	1			1		1		1	1
10	1	1	1	1			1	1		1	1
11	1	1	1		1		1	1	1	1
12	1	1	1	1				1	1	1	1
Sheet4

Excel 2007

 

[MDuff]

Sorry first screen shot was missing monday here it is updated

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M
5	Mon	Tue	Wed	Thr	Fri	Sat	Sun	Mon	Tue	Wed	Thr	Fri
6	1	1	1	1	1			1	1			1
7	1	1	1	1	1			1	1	1	1
8	1	1	1	1	1			1	1			1
9	1	1	1	1	1			1		1	1
10	1	1	1	1	1			1	1	1		1
11	1	1	1	1		1		1	1	1	1	1
12	1	1	1	1	1				1	1	1	1
13	1	1	1	1	1			1	1			1
14	1	1	1	1	1			1		1	1
Sheet4

Excel 2007

 

[Aladin Akyurek]

What is desired?

 

[MDuff]

What is desired?

thanks for the reponce but...

Sorry Aladin not sure what exactly you mean by Desired? what I am looking for is to count the max number of days (1) that are consecutive acoross the row

 

[Rick Rothstein]

For Row 6... is the count you want 5 or 7 (in other words, do we ignore weekends or not)?

 

[Aladin Akyurek]

thanks for the reponce but...

Sorry Aladin not sure what exactly you mean by Desired? what I am looking for is to count the max number of days (1) that are consecutive acoross the row

Care to state the desired result per row (record) for the sample you posted?

 

[MDuff]

hope this helps

the result in this example would be 8 and yes I want to include weekend

Excel Workbook
	D	E	F	G	H	I	J	K	L	M	N	O	P
53	1		1	1	1	1	1	1	1	1
Sheet4

Excel 2007

 

[MDuff]

For Row 6... is the count you want 5 or 7 (in other words, do we ignore weekends or not)?

Sorry In this example I would want 5 We need to include weekends

 

[Aladin Akyurek]

hope this helps

the result in this example would be 8 and yes I want to include weekend

Excel Workbook
	D	E	F	G	H	I	J	K	L	M	N	O	P
53	1		1	1	1	1	1	1	1	1
Sheet4

Excel 2007

Q6, control+shift+enter, not just enter, and copy down:

=MAX(FREQUENCY(IF(B6:M6=1,COLUMN(B6:M6)),IF(B6:M6<>1,COLUMN(B6:M6))))

 

[MDuff]

Awsome thanks!!!!