Excel Timesheet Counting problem
Depends on how you have each day set up.
If you have a daily cell value with hours in it you could use something
like:
If Range("A1:A7").value <"" then msgbox "The Employee has worked 7 days
straight."
' Where A1:A7 is the hrs worked for each day.
Corey....
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
|