View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
caj caj is offline
external usenet poster
 
Posts: 23
Default Count number of possible occurances bi-weekly (Can this be done)?

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.