Does anyone have any idea how I would start to setup an excel spreadsheet for allocating carparks to employees.

At my work we have 3 car parks that are shared between 40 people. Evey 2 weeks - the car park is allocated to another person to use for the next 2 weeks. I have tried to set one up but failed totally.

I need to have the ability to add new staff names and remove staff names of people that have left. New employees go to the end of the list.

And the abiltiy to set the date eg: Week commencing 02 April 2007.

Any assistance/advise would be appreciated.