This is a School Term Calendar Generator spreadsheet. It allows the user to quickly calculate how many days of term time, holidays, and inset days. It summaries them quickly and allows you to amend dates simply. This is an essential for anyone who is planning the school year or is concerned about holiday dates changing. It also helps visualize the school year as each day becomes highlighted in the calendar automatically. The spreadsheet is dynamic so different years can be looked at by changing the date range. Bank holidays are connected by an API to the government website which allows them to be updated to the correct year at the click of “Refresh All”.