I need to summarize employee attendance data based on a weekly basis. Right
now my spreadsheets are setup for a monthly basis. The spreadsheets have all
the data in a daily format so it is there. The problem I am having is
summarizing it by a time frame, in this case a week. The current setup has no
time frame restriction, I have a new workbook for each month. Rather then
create another workbook to gather the data on a weekly basis and one for a
monthly basis I would rather use the current workbook.

Here is where it gets interesting. I need to summarize by department, shift,
and week. Looking for some ideas.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.