Holiday planner

As this is my first post hello everyone :-)

I have a planner to track numerous staff across different roles, I want to be able to enter all the holidays in the planner then have a summary sheet of each weeks annual leave via a "week drop down menu" any hints or tips would be greatly appreciated.

Thanks Andy

Thanks, the formula for the week drop down works excellent :-)

I want to fill the summary sheet with drivers/O.D.F names on the days/dates there on leave, but again thanks that a great start for me

Thanks again for your time popipipo,

like the date change :-), on the summary page to display just those on annual leave would it be best to record a macro to filter or is there a formula i could adapt?

Thanks Andy

Is there a formula to fill the summary sheet with just the people who are on leave?......

Thanks Andy