I need to count the number of occurances that should have occured. The sheet
has different departments that are inspected every week or biweekly and I
need to calculate the number of inspections that should have occured
biweekly. The sheet is basically set up like:
1/1 1/8 1/15 1/22 (1st monday in week)
dept1 weekly X X X
dept2 biweekly X X
dept3 weekly X
dept4 biweekly X X

returns:
Weekly complted 2 0 1 1
Weekly required 2 2 2 2

How can I set this up so that it will give the total number of inspections
that should be done by bi-weekly.