How many days in a row does an employee work within a 2 month peri

[LEG]

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.

 

[trip_to_tokyo]

Use the following:-

=COUNTA(A3:BI3)

This will count the number of cells that are not blank in the specified
range.

This will give you the number of days that they worked.

If my comments have helped please hit Yes.

 

[trip_to_tokyo]

Hi LEG.

I have just put up a worked example for you at:-

http://www.pierrefondes.com/

- home page (item number 24).

Please hit Yes if my comments have helped and / or my proposed solution is
correct.

My example is in EXCEL 2007.

Thanks.