Return a 7 day week attendance

[scorpio61]

Is it possible to return a 7 day week attendance, using a week ending date, from a yearly rota?

It is based on a shift pattern so there are breaks between dates.

I have a rota split into 12 tabs (monthly) and require a tab to show who is at work on a specific week, by using a week ending date (every Thursday)

I am using excel 2010 and would like to be compatible with 2003,

 

[Robert Mika]

Hi scorpio and welcome to the board.
Coudl you post a sample of your data from one tab ?

 

[scorpio61]

Hi Robert,

Thanks for your reply, I hope you can resolve my issue, I have pasted a copy of the tab for the week ending sheet I am trying to amend, it is taken from a template from another excel web site, each employee has their own ID and on the monthly return have a P inserted into the days they have attended and I have monthly return for this: =VLOOKUP($C$8,January!$B$11:$L$60,8,FALSE)

What I would like is a weekly return if possible,



Employee ID : 1 Year : 2011

Name : john smith Hiring Date : 6-Sep-11

Title : Coordinator Departure Date : 20-Sep-11

Department : shoes Week-Ending: 6-Jan-11

Week-Ending Working Days Present Sick Vacation Other Not Working Yet/Anymore
Beginning Balance 0 0 0
Friday 1 0.0 0 0 0 0
Saturday 1 0.0 0 0 0 0
Sunday 1 0.0 0 0 0 0
Monday 1 0.0 0 0 0 0
Tuesday 1 0.0 0 0 0 0
Wednesday 1 0.0 0 0 0 0
Thursday 1 0.0 0 0 0 0
Total 7 0.0 0 0 0 0
Carry Over 0 0 0
Last Balance 0 0 0

 

[scorpio61]

I can not get the paste function to insert a snap shot of the tab required, is there a way round this to assist in your information required,