Why a rolling schedule works better than a fixed one
Most printable cleaning charts give each job a fixed day: bathrooms on Saturday, floors on Wednesday. Miss a Saturday and the chart has nothing to say about it. This sheet works from the date a job was last done instead. Clean the bathroom on a Monday and the next one is due the following Monday, not "some Saturday".
Using it day to day
- Open the This Week tab. Everything overdue is at the top, then today's jobs, then the rest of the next seven days.
- Do a job, then go to the Tasks tab and change its "Last done" date to today. Quickest way: click the cell and press Ctrl + ; — it types today's date in both Excel and Google Sheets.
- That job drops off the list and its next date moves forward on its own.
How "next due" is worked out
For days and weeks it's simple addition: last done on 3 March, every 2 weeks, next due 17 March. For months, the sheet moves to the same day of the next month — and when that day doesn't exist, it uses the last day of the month. A job last done on 31 January with "every 1 month" is due on 28 February (29 in a leap year), not on 3 March.
A job with no "Last done" date at all counts as due today, so new jobs you add don't get lost.
Sharing the jobs
Put up to six names on the Settings tab. For each job you can choose one person, or "Rotate". Rotating jobs move to the next name on the list each week, and the jobs are staggered so that one person doesn't end up with every rotating job in the same week. In the sample above, Sam has a heavier week; the week after, the rotating jobs move on to the next person.
What's in the starter list
The file comes with 23 common jobs across the kitchen, bathroom, bedrooms, living room and the rest of the house, from daily ones (counters, dishwasher) to twice a year (turning the mattress). Delete the ones that don't apply, change the frequencies to suit your home, and add your own.
What it won't do
It doesn't send reminders — a spreadsheet can't. If you need a nudge, open the This Week tab at the same time each day, or pin it on your phone in the Google Sheets app.