Duty Roster in Excel

Hiya I currently run a duty roster for 12 people who work a day each i turn and who share the responsibility of working one weekend in 12. I run this on a points system so 1 point for a day and 3 points for the whole weekend. I have to manually keep a track from rosters i keep in word documents.

I want an easier system, so that each member listed is able to see when they are duty and has a calculated total of every duty they keep.

Is there a formula for this?

Paul.

Maybe post a copy of your workbook..is there a fixed schedule for people to work, or do they work when they want and the points get added as much as they work