2011 jan 1 2 3 4 5 feb 1 2 3 4
Place x in correct column
a x 0 x 0 x x x
b x 0 x x 0 0 x
c 0 0 0 x x 0 x
d x 0 x 0 x x x
e x 0 0 x 0 0 x
f 0 x x 0 x 0 x
g 0 x 0 0 0 0 0
h 0 x x x x 0 x


The above indicates members and their attendance.
Assuming this is the 2nd week of Feb, member b has missed 3 consecutive weeks.
Member h has missed 2.
Member g has missed 5.

I need to generate a report showing those that are 3 or greater.
My members will total in excess of 500.
I need a formula to calculate the current consecutive absences and the counter needs to restart on each individual that shows up on the current week as being present.
If they don't show up then add 1 more to the counter.
If H is present, then counter goes back to 0.
If G misses the counter goes to 6.
x=present
0=missed
I prefer using the actual Sunday date instead of 1,2,3,4,5.
I prefer using blank instead of 0.
tarquinious solution last works however I want to use this on a 52 week calendar. The calendar will have several consecutive blank cells however I only want to count from the current week backwards. consecutively

I need to implement this program asap if some one could help. thanks