Calender and organizer tips for excel

[Jeff]

Hi,

I need to make a sheet that contains a list of my team members and the
days they want to take a day off.

My team consists of nine people and there should always be 6 people
present.
Everyone has a certain amount of days they can plan as a day off.
We work in a shiftsystem that changes according a certain schedule.

I want this sheet to show me when there are more than 3 people that
want to take a day of.
Decrease the amount of days left they can plan.
Even count the days they are ill.

And much more.
I don't need you to make this sheet, but I'm looking for calendertools
with wich I can make this kind of calender.
And if possible that I just have to change the year to have a new one
for next year.

Just looking for tips!

Thanks

 

[Gord Dibben]

Maybe one of these will do the trick.

http://office.microsoft.com/en-us/templates/results.aspx?qu=shift+schedule&av=TPL000

Or at least get you started on a base.


Gord Dibben MS Excel MVP

 

[Jeff]

Okay thanks!!!

Maybe one of these will do the trick.

http://office.microsoft.com/en-us/templates/results.aspx?qu=shift+schedule&av=TPL000

Or at least get you started on a base.


Gord Dibben MS Excel MVP