I’d like a practical solution as each academic year requires a new set of term dates. At the moment this is created manually - which is painfully time-consuming.
what you have attached as an example works great for spreadsheets (excel, google sheets) but not so much in the sense of “database” first applications like Coda.
Before migrating over, you may want to carefully consider if this new way of thinking/working is suitable or worth the extra steps.
How i would tackle this/coda-fying it…
Tables required are
Students
Term Dates (here you can create a canvas button to create new rows for new set of term dates from a start date)
Attendance (junction table where Students and Term Dates are linked via each row)