View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LEG LEG is offline
external usenet poster
 
Posts: 16
Default How many days in a row does an employee work within a 2 month peri

Hi!
In my worksheet I have in coloumn A employees and in coloumn C and forward I
have every day in a two month period. F.eks. 1. november to 31. december (61
coloums in all). In each cell there is either a blank cell og a no. which
represents the no. of hours they worked that day.

I need a formula/macro/VBA ... which tells me how many days in a row each
employee had in the two month periode.

Any help would be great.

--
LEG-denmark