How to Track Homeschool Attendance Hours and Days for Your State
The hours requirement is the only part of homeschooling that can fail without anyone noticing until it is too late to fix.
A budget overrun announces itself. A subject the child is struggling with announces itself loudly and repeatedly. But an hours shortfall is silent, because the gap that produces it is about five hours a week — and no week in the history of homeschooling has ever felt five hours short.
This is the log, the arithmetic, and the weekly check that turns that from an April problem into a week-six adjustment.
First: Write Down What You Are Counting Toward
Before any of the mechanics, put your own state’s figures somewhere permanent and in the file itself — not in a bookmark.
What to record, once, at the start of the year:
- Whether notification or a letter of intent is required, and by what date
- Required subjects, in your state’s own wording
- Minimum days, if days are counted
- Minimum hours, if hours are counted
- Whether an assessment or evaluation is required, and in what form
- What records you are required to keep, and for how long
These requirements are genuinely different from state to state — some count days, some count hours, some count both, some count neither — so this article deliberately does not tell you what yours are. It uses 180 days and 900 hours throughout as a worked example only. Look yours up once, write it at the top of the log, and every number below becomes yours.
The Log
One row per school day. The essential columns:
| Date | Day | Math | Lang. arts | Science | History | Other 1 | Other 2 | Total | Notes |
|---|---|---|---|---|---|---|---|---|---|
| 2026-08-17 | Monday | 1.0 | 1.0 | 0.5 | 0.5 | 0.5 | 0.0 | 3.5 | |
| 2026-08-18 | Tuesday | 1.0 | 1.0 | 0.5 | 0.5 | 0.5 | 0.5 | 4.0 | |
| 2026-08-19 | Wednesday | 1.0 | 1.0 | 1.0 | 0.5 | 0.0 | 0.5 | 4.0 | |
| 2026-08-20 | Thursday | 1.0 | 1.0 | 0.5 | 0.5 | 0.5 | 0.5 | 4.0 | |
| 2026-08-21 | Friday | 0.5 | 0.5 | 1.0 | 0.5 | 1.5 | 0.0 | 4.0 | Co-op — science, art, PE |
Two formulas do all the work:
Day of week =IF(A5<>"", TEXT(A5,"dddd"), "")
Day total =IF(A5<>"", SUM(C5:H5), 0)
And two summary cells, which are the actual point of the exercise:
Days completed =COUNTA(Date_column)
Hours logged =SUM(Total_column)
Days remaining =Days_required - Days_completed
Hours remaining =Hours_required - Hours_logged
Split by subject rather than logging one lump figure per day. It costs nothing extra at entry time and answers a question you cannot answer retrospectively: how many hours of science did we do this year. If your state names required subjects, that is the question you will be asked.
The Arithmetic That Makes It Urgent
Take the week above — Monday 3.5, then four days of 4.0. That is 19.5 hours, and it is a completely normal week. Nothing was skipped. The co-op day counted. The children worked.
Run it out over a 36-week year:
36 × 19.5 = 702 hours.
Against a 900-hour target, that is a 198-hour shortfall.
The required pace is 900 ÷ 36 = 25 hours a week. The gap is 5.5 hours a week — 22% — and it is undetectable at the scale of a single week.
Now the part that matters:
| Found in | Logged | Remaining | Weeks left | Required pace |
|---|---|---|---|---|
| Week 6 | 117 hrs | 783 hrs | 30 | 26.1 hrs/week |
| Week 15 | 292.5 hrs | 607.5 hrs | 21 | 28.9 hrs/week |
| Week 22 | 429 hrs | 471 hrs | 14 | 33.6 hrs/week |
| Week 30 | 585 hrs | 315 hrs | 6 | 52.5 hrs/week |
Week six needs 6.6 extra hours a week — forty minutes a day, or simply counting things you were already doing. Week thirty needs 52.5 hours a week, which is not a plan, it is a fiction.
Every row in that table costs one subtraction. That is the whole intervention.
The Four Things Families Forget to Count
Before you add hours to the week, check whether the hours already happened and went unlogged. In the worked example, most of the gap was recoverable this way.
Co-op days. A four-hour co-op morning with science, art and PE is instruction. Log it by subject like any other day — note it in the Notes column so the record explains itself later.
Field trips. A museum tied to a zoology unit is not a day off. The worked family ran six trips in the year at four to five hours each; unlogged, that is roughly 25 hours thrown away.
Read-alouds and independent reading. Time a child spends reading assigned material is instruction in most reasonable definitions of the word. Check yours, then count it.
Music practice, sport, and anything under a required-subject heading. If PE or fine arts is on your state’s list, the piano practice you are already paying for probably belongs in the log.
None of this is inflating the record. It is recording accurately in the first place, which is a different thing — and the distinction is worth being deliberate about, because a log that counts things that did not happen is worse than no log at all.
The Weekly Habit
Three minutes, Friday afternoon:
- Fill in any day rows you missed this week.
- Look at two numbers: hours remaining, and weeks remaining.
- Divide one by the other. If the answer is meaningfully above your normal week, adjust now.
That is it. Not a review, not a reconciliation — one division. Done every week, the week-30 row in that table above never happens to you, and the record you hand to a reviewer in May was written in real time rather than assembled from memory.
The full planner setup shows how the hours log sits alongside the budget, the grade record and the state requirements page in one file — which matters mainly because a log kept in a separate document is a log that stops being updated in November.
Related Reading
- Homeschool planner spreadsheet for Excel and Google Sheets — the pillar: all four record-keeping jobs in one file.
- How much does it cost to homeschool one child per year — the money side of the same worked year.
- Homeschool planner for multiple kids in different grades — logging hours per child when the subjects overlap.
Featured on ReadySheetGo
Homeschool Curriculum Planner & Budget — $14.99
The Attendance Tracker is the log above, built: 200 day rows, hours split across Math, Language Arts, Science, History and two subjects you name yourself, a day total calculated on every row, the weekday filled in from the date, and a Notes column for the co-op day and the field trip that explain an unusual row later.
The Dashboard runs the arithmetic that makes it useful — days completed, days required, days remaining, total hours logged, hours required, hours remaining and your attendance rate, all live. That is the week-6-versus-week-30 table above, calculating continuously, without you doing the division.
State Requirements is where your own state’s notification deadline, required subjects, minimum days, minimum hours, assessment type and record-keeping rule are written down — inputs you fill in, never figures baked into the file — and the Dashboard counts toward the numbers you entered there. Field Trips & Extras records date, location, subjects covered and cost, so trips reach both the hours count and the budget.
Alongside them: Curriculum Shopping and a five-category budget summary, Cost Comparison, a Grade Tracker returning a percentage per assignment, a Weekly Schedule in half-hour blocks, a Resource Library, and a Year Review setting budgeted against actual.
Eleven tabs, 541 formulas, and a worked sample family with a term of hours already logged. Works in Excel and Google Sheets. No macros, no add-ons. It organises your own records — it is not legal advice and does not interpret your state’s homeschool law.
Get the Homeschool Curriculum Planner & Budget →
Frequently Asked Questions
How do I track homeschool hours and days?
One row per school day, hours split across the subjects you teach, and a day total that calculates itself — then a single running comparison against the target your state sets. The split by subject matters because some states specify required subjects, and a lump 'four hours' figure cannot answer that question later. Log on the day; every failure in homeschool record keeping is a reconstruction failure, not a record-keeping one.
What counts as an instruction hour in homeschooling?
Your state defines this, and the definitions genuinely differ — so look yours up once and write it at the top of your log rather than assuming. What is consistent is that families routinely undercount by leaving out things they were already doing: co-op classes, field trips, read-aloud time, documentaries tied to a subject, music practice, and sport where PE is a required subject. In the worked example those omissions were most of a 198-hour gap.
How many hours a week do I need to homeschool?
If your state asks for 900 hours across a 36-week year, that is 25 hours a week — but a full, unremarkable homeschool week where nothing is skipped commonly logs around 19.5. That 5.5-hour weekly gap is invisible week to week and fatal by April, which is the entire reason to hold a running total rather than a pile of daily notes.
Do I need to keep homeschool attendance records if my state doesn't require them?
Keeping a log is cheap and being unable to produce one is not. Requirements change, families move between states, and an hours-and-subjects record is also what a portfolio review, an umbrella school or a future transcript is built from. A log takes about three minutes a week to maintain and cannot be recreated afterwards.