Emily ParkerBy Emily Parker

Updated November 2026

A rotating chore chart template in Excel lets you list your household tasks once and have them shift to a new person automatically each week. Once it’s set up, you only need to change the names or the start date, and the assignments update on their own. This guide walks through building one from a blank spreadsheet in six steps.

Step 1: Set Up Your Task and Person Lists

Open a new workbook and create two separate lists. On the first sheet, type your household members’ names down column A, starting in cell A2. On the same sheet, list your recurring chores down column D, starting in D2, such as “Dishes,” “Trash,” “Vacuum,” and “Bathroom.” Keeping these lists separate makes the rotation formula easier to write and easier to edit later.

Shopping for one? See our guide: 5 Best Editable Chore Chart Template Excel Options for Busy Families (2026).

Step 2: Build the Weekly Grid

On a second sheet, label cell A1 “Week,” then type the week start dates across row 1 (B1, C1, D1, and so on). In column A below, list the chores. Each cell in the grid will hold the name of the person responsible for that chore that week. Plan for at least 12 weeks so the rotation covers a full quarter.

Step 3: Write the Rotation Formula

The rotation depends on a simple offset. In cell B2, enter a formula that picks a name from your member list based on the chore’s position and the week’s position. A common pattern looks like this:

  • Use INDEX and MOD together. The formula returns a name from the list using the remainder after dividing the combined chore and week numbers by the number of people.
  • Add ROW and COLUMN offsets. Subtract 1 from each so the first chore and first week start at position 0, which keeps the math clean.
  • Copy the formula across the grid. Drag the fill handle right and down so every cell calculates automatically.

Test the first week manually. If two chores land on the same person, check that your offsets start at the right number.

Step 4: Format for Easy Reading

Use Excel’s conditional formatting to color each person’s name a different shade. Select the grid, go to Home, then Conditional Formatting, and create a rule for each name. Bold the header row and freeze the top row and first column so labels stay visible when you scroll. Print settings matter too: set the page to landscape and fit all columns on one page width.

Step 5: Add a Start Date Cell

Put a single input cell at the top, such as “Start Date,” and have your week headers pull from it with a simple formula that adds seven days for each column. Changing one date then updates the whole calendar. This also helps when you restart the rotation after a school break or a move.

Step 6: Save a Master Copy and Share It

Save the file with a clear name and keep a blank version as a backup. If your family uses a shared drive, store it there so everyone can check their assignments. Some families print the current week each Sunday and post it on the fridge, which works well for younger kids who aren’t yet checking a screen.

Common mistakes to avoid

  • Changing the number of people without updating the formula’s range, which can leave blank or repeated names.
  • Hard-typing names into the grid instead of letting the formula assign them, which breaks the rotation as soon as you edit anything.
  • Forgetting to lock the reference cells, so a stray keystroke overwrites your member list.
  • Making the rotation too fast. Weekly swaps suit most families, but a chore that takes 30 minutes may need a longer cycle.
  • Skipping a test week. Run the template for one week before you share it so you can catch errors early.
  • A laminated dry-erase weekly board works well if you want to post the rotation where everyone sees it and still update it by hand when a swap is needed. View on Amazon
  • Colored magnetic name tags let kids move their own assignments on a metal fridge or whiteboard, which helps them take ownership. View on Amazon

FAQ

Do I need to know advanced Excel formulas?

No. You only need INDEX, MOD, and basic cell references to build a working rotation. The steps above cover everything required, and you can copy the formula pattern once you’ve tested it.

How often should the chores rotate?

Weekly rotation is the most common choice because it gives everyone a fair share without frequent confusion. Families with many tasks sometimes rotate every two weeks instead.

Can I use this template for roommates or adults?

Yes. The same structure works for any group that shares chores. Just replace the member names and adjust the task list to match your shared responsibilities.

Conclusion

A rotating chore chart in Excel takes about an hour to build and then runs itself with almost no upkeep. Start with a short task list and a test week, then expand as your family settles into the routine. Once it’s working, you’ll spend far less time reassigning chores and more time on everything else.

Ready to choose one?

Emily Parker

About Emily Parker

Emily Parker is part of our editorial team and reviews and edits our busy-mom life guides, checking product details against manufacturer specifications and owner feedback.