Calender and organizer tips for excel
 

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

Calender and organizer tips for excel
 

Maybe one of these will do the trick.

http://office.microsoft.com/en-us/te...dule&av=TPL000

Or at least get you started on a base.


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 16:59:41 +0100, Jeff wrote:

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

Calender and organizer tips for excel
 

Okay thanks!!!


On Wed, 31 Oct 2007 10:19:32 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Maybe one of these will do the trick.

http://office.microsoft.com/en-us/te...dule&av=TPL000

Or at least get you started on a base.


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 16:59:41 +0100, Jeff wrote:

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