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

L

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.
 
T

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.
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top