ShiftRotations
Menu

Duty Roster Maker

Type the names and pick the dates. Everyone takes turns evenly, gets rest after a duty and shares weekends and holidays fairly, and anyone on leave is skipped. Download a PDF or Excel roster. Free, no sign-up.

How to make a duty roster

  1. Name the duty — CQ, staff duty, fire watch, lunch duty, on-call, kitchen — and your unit or team.
  2. List the people, one per line. If two people are tied, whoever has gone longest without any duty goes first, then whoever is higher on the list.
  3. Pick the dates and how many people are on duty each day.
  4. Set the rules: how many days off after a duty, which days need cover, and whether weekends and holidays are counted separately.
  5. Add leave and other absences so those people are skipped.
  6. Download the roster as a PDF to post, or as Excel or CSV to edit. Each person can add their own duty days to their phone calendar with the .ics button.

How the fair rotation works

  • Longest break goes next. Each day, the person who has gone the most days without the duty is picked. Everyone else's count goes up by one.
  • Weekends and holidays are shared separately. With the separate count on, weekend and holiday duties rotate on their own, so they end up spread evenly — nobody pulls every Saturday.
  • Absences pause the count. Days on leave don't count as a break, so people who were away don't come back owing a string of duties — and don't skip their turn either.
  • Rest after duty. Nobody is picked again until their rest days have passed. If there aren't enough people to cover a day, the roster says so instead of quietly breaking the rule.

These are the same principles the U.S. Army uses on the DA Form 6 duty roster (AR 220-45 and DA Pam 220-45). See CQ and staff duty explained for how military duty rosters work.

Duty roster format: what to include

A clear duty roster answers "who, what, when" at a glance. Include:

ColumnWhy it matters
Date and daySo nobody has to work out which Tuesday it is.
DutyUseful when one sheet covers more than one duty.
Name(s)Who is responsible that day.
InitialsSpace to confirm the duty was done, or to note a swap.
TotalsWeekday and weekend counts per person, so the roster is visibly fair.

Here is a sample one-week duty roster for one person per day, with one day of rest required after each duty:

DateDayNameInitials
Nov 2MonAdams
Nov 3TueBaker
Nov 4WedChen
Nov 5ThuDavis
Nov 6FriEvans
Nov 7Sat (weekend)Adams
Nov 8Sun (weekend)Baker

Who uses duty rosters?

  • Military units: CQ (charge of quarters), staff duty, fire watch, guard and barracks details. How CQ and staff duty work.
  • Schools: lunch, recess, bus and hallway duty for teachers.
  • Hospitals and clinics: on-call and weekend cover. For full shift rotas see nurse schedules.
  • Offices and homes: cleaning, kitchen, opening and closing, and shared-house chores.
  • Volunteer groups and churches: greeters, ushers, cleanup and rota-based volunteering.

Scheduling everyone's regular shifts instead? Use the shift schedule maker or a free schedule template.

Frequently asked questions

What is a duty roster?

A duty roster is a list that shows who performs a recurring duty on each date — for example CQ or staff duty in the military, lunch or bus duty at a school, on-call cover, or cleaning in a shared house. Its job is to share the duty out fairly and make it clear who is responsible each day.

How do you make a fair duty roster?

Rotate the duty so the person who has gone longest without it is next, keep a separate count for weekends and holidays so nobody gets stuck with all of them, give everyone a rest day after a duty, and skip people while they are on leave without letting their absence count as a break. The duty roster maker above does all of this automatically.

What is the difference between a duty roster and a work schedule?

A work schedule shows everyone's shifts and hours. A duty roster covers one extra duty that rotates through a group — one or two people per day — and is mainly about fairness. For staff shifts, use the shift schedule maker instead.

Can I make a duty roster in Excel?

Yes. Make the roster here and click Excel to download a .xlsx file with the date, day, duty and name for each day, plus a totals sheet. You can open it in Excel or Google Sheets and edit it there.

How do I handle someone on leave?

Add them under "Unavailable" with the dates. They are skipped on those days, and their count is paused rather than growing, so they don't jump to the front of the line the day they return — the same way an "A" (authorized absence) works on the Army's DA Form 6.

Can two people be on duty each day?

Yes. Set "People per day" to 2, 3 or 4 and the roster picks that many each day, still rotating fairly. If two roles come from different groups — for example a CQ NCO and a CQ runner — make one roster for each group.

Is this an official DA Form 6?

No. It follows the same fairness rules as the Army's DA Form 6 (longest break goes next, separate weekend and holiday count, absences pause the count), so it is useful for planning and checking a roster, but your unit may require the official form.

More free shift tools