Thread: count number of weeks missing for each individual in a database
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default count number of weeks missing for each individual in a database
Hi,

If Bob's weeks worked are in range B2:B7, then the weeks missing would be

=52-count(B2:B7)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"pumpkin" wrote in message
...
Hi,

I need to measure attendace for the employees. I have a list of weeks
worked
(eg. below) for each employee (numbered from 1-54) and I need to work out
the
weeks that have not been worked and whether they are consecutive or not.

Please help :-)

bob jack
3 2
4 13
8 14
9 15
10 16
11 17

Reply With QuoteReply With Quote