counting consecutive days worked.....

[chris_sweezy]

Trying to count employee's consecutive days worked (no more than 13, 14th has to be a rest day). Problem is.. count should restart after an absence.

	8/1	8/2	8/3	8/4	8/6	8/7	8/8
Consecutive Days Worked	In	In	In	In	In	In	In
	1	1	1	0	1	1	1
	1	1	0	1	0	1	1
	0	0	0	0	0	0	0
	1	1	1	1	1	1	1
	1	1	0	0	1	1	1

 

[chris_sweezy]

EMPLOYEE NUMBER	EMPLOYEE NAME	CLASS		Consecutive Days Worked	8/1	8/2	8/3	8/4	8/6	8/7	8/8	8/9	8/10	8/11	8/12	8/13	8/14	8/15	8/16	8/17	8/18	8/19	8/20	8/21	8/22	8/23	8/24	8/25	8/26	8/27
APA6128	ALL, DAVID "RANDY"	GF		#VALUE!	1	1	1	0	1	1	1	1	1	1	1	1	1	1	1	1	0	0	1	1	1	1	1	1	1	0
APA0430	ALVARADO, JOSE ANGEL	Lead			1	1	0	1	0	1	1	1	1	1	1	1	1	1	0	1	1	0	1	1	1	0	1	1	1	0
APA8155	ARDOIN, BRANDON	Lead			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
APA0057	ARRIAGA MORALES, JUAN	Carpenter			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0	0

Maybe this helps.. need to know how many consecutive days worked from current date. Restarting when day off (o) occurs.

 

[Peter_SSs]

need to know how many consecutive days worked from current date.

You have mentioned this a couple of times, yet nowhere on your sheet are any dates so how do we know where to start and which way to count?

Also, it might help if you included the (manually entered) expected results for your data.

 

[chris_sweezy]

Good morning! The formula is working now. Thank you. Could we tweak it? An employee can't work more than 13 consecutive days. If day is missed, count starts over. Certain this would include TODAY formula, but have no idea how to implement. My apologies for not stating objective more clearly initially. Again, thank for your patience and brilliance! You are very helpful.

 

[shg]

As Peter points out, there are no dates in your example, so there's no way to know how they relate to today.

Also, some specific examples of what your trying to do would be helpful.

 

[shg]

Re your PM, please see post #14 , and keep your questions in the forum.

Thanks.

 

[chris_sweezy]

As Peter points out, there are no dates in your example, so there's no way to know how they relate to today.

Also, some specific examples of what your trying to do would be helpful.

An employee can't work more than 13 consecutive days. If day is missed, count starts over. Certain this would include TODAY formula, but have no idea how to implement. My apologies for not stating objective more clearly initially. Again, thank for your patience and brilliance! You are very helpful.

EMPLOYEE NUMBER	EMPLOYEE NAME	CLASS		Consecutive Days Worked	8/1	8/2	8/3	8/4	8/6	8/7	8/8	8/9	8/10	8/11	8/12	8/13	8/14	8/15	8/16	8/17	8/18	8/19	8/20	8/21	8/22	8/23	8/24	8/25	8/26
APA6128	ALL, DAVID "RANDY"	GF		8	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
APA0430	ALVARADO, JOSE ANGEL	Lead		7	1	1	1	0	1	1	1	1	1	1	1	1	1	1	1	1	0	0	1	1	1	1	1	1	1
APA8155	ARDOIN, BRANDON	Lead		0	1	1	0	1	0	1	1	1	1	1	1	1	1	1	0	1	1	0	1	1	1	0	1	1	1
APA0057	ARRIAGA MORALES, JUAN	Carpenter		12	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
APA1964	BARULICH, NICHOLAS	GF		8	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0
APA9168	BOLDEN, KENNETH	Lead		12		1	0	0	1	1	1	1	1	1	1	1	1	1	0	1	1	0	1	1	1	1	1	1	1
APA8349	BROWN, JASON	Foreman		8	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0	1	1	0	1	1	1	1
APA3413	BROWN, ROBERT	Lead		11	1	1	1		1	1	1	1	1	1	1	1	1	1	1	1	1	0	1	0	1	1	1	1	1
APA7055	BROUSSARD, GREGORY	Helper		0	0	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0	1	1	1	1	1	1	1
APA0028	BUCKNER, JEREMY	Carpenter		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

 

[chris_sweezy]

EMPLOYEE NUMBER	EMPLOYEE NAME	class		Consecutive Days Worked	8/1	8/2	8/3	8/4	8/6	8/7	8/8	8/9	8/10	8/11	8/12	8/13	8/14	8/15	8/16	8/17	8/18
APA6128	ALL, DAVID "RANDY"	GF		8	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0
APA0430	ALVARADO, JOSE ANGEL	Lead		5	1	1	0	0	1	1	1	1	1	1	1	1	1	1	0	1	1
APA8155	ARDOIN, BRANDON	Lead		3	0	0	0	1	0	1	1	1	1	1	0	0	0	0	0	0	0
APA0057	ARRIAGA MORALES, JUAN	Carpenter		9	1	1	1	0	0	0	0	0	0	0	1	1	1	1	1	1	1
APA1964	BARULICH, NICHOLAS	GF		8	1	1	0	1	1	1	1	1	1	1	1	1	1	1	0	1	1
APA9168	BOLDEN, KENNETH	Lead		12	1	1	1	0	1	1	1	1	1	1	1	1	1	1	1	1	1
APA8349	BROWN, JASON	Foreman		11	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
APA3413	BROWN, ROBERT	Lead		7	0	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
APA7055	BROUSSARD, GREGORY	Helper		0	0	0	0	1	1	1	1	1	1	1	0	0	0	0	0	0	0
APA0028	BUCKNER, JEREMY	Carpenter		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
APA7704	CALDWELL, MATTHEW	Helper		3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

 

[chris_sweezy]

As Peter points out, there are no dates in your example, so there's no way to know how they relate to today.

Also, some specific examples of what your trying to do would be helpful.

The columns do have dates. It just occurred to me.... the font is white! Kinda hard to see... LoL...

 

[chris_sweezy]

An employee can't work more than 13 consecutive days. If day is missed, count starts over. Certain this would include TODAY formula, but have no idea how to implement. My apologies for not stating objective more clearly initially. Again, thank for your patience and brilliance! You are very helpful.

The columns have dates. An employee can't work more than 13 consecutive days. If day is missed, count starts over. Certain this would include TODAY formula, but have no idea how to implement. My apologies for not stating objective more clearly initially. Again, thank for your patience and brilliance! You are very helpful.

 

[Peter_SSs]

The columns do have dates. It just occurred to me.... the font is white! Kinda hard to see... LoL...

That sure was a trap!

OK, can you post another set of sample data (with dates we can read) with the expected result for each row entered manually and explain again why those are the expected results?

Also, why is just one date (8/5) missing from your previous sample data?