There are a number of ways to do this. How is your data laid out? How many
columns wide is the data? What does the data in each column mean? Are
non-worked days blanks or do they have a 0?
There are many way to lay out a timesheet, and a solution that applied to
one format may not work in another. You need to supply much more
information. Details count.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
wrote in message
ps.com...
I have an excel timesheet that I want to do a simple task - count if an
employee ever works 7 days in a row.
Any Ideas?
Thanks,
Patrick