View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jeff[_9_] Jeff[_9_] is offline
external usenet poster
 
Posts: 8
Default 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