School calendars 2016/17 (UK)
in Excel format
Calendar templates for the UK school year 2016/17
in Microsoft Excel format to download, edit and print
Advertisement
The bank holidays, clock changes and working days of the school year 2016/17, the usual school holidays in England (half terms, Christmas, Easter and summer) and a note on school terms across the UK are listed below the templates.
School calendars 2016/17 UK for Microsoft Excel,
landscape orientation (4 templates)
Template 1:
School year calendar 2016/17 (UK)
landscape
- runs from 1 August 2016 to 31 July 2017
- one A4 page, landscape orientation (horizontal)
- years marked in different colours for easier identification
- UK edition with bank holidays highlighted in red
- with week numbers
- fully editable and customisable
Download template 11 page · 39 KB · xlsx file
Template 2:
School year calendar 2016/17 (UK)
landscape, 2 pages
- runs from 1 August 2016 to 31 July 2017
- two A4 pages, landscape orientation (horizontal)
- half a year (six months) per page
- separate pages for the first and second half of the year
- years marked in different colours for easier identification
- UK edition with bank holidays highlighted in red
- with week numbers
- fully editable and customisable
Download template 22 pages · 42 KB · xlsx file
Template 3:
School year calendar 2016/17 (UK)
landscape, linear
- runs from 1 August 2016 to 31 July 2017
- one A4 page, landscape orientation (horizontal)
- linear calendar (days arranged horizontally)
- names of the months arranged vertically down the left side
- years marked in different colours for easier identification
- UK edition with bank holidays highlighted in red
- with week numbers
- fully editable and customisable
Download template 31 page · 32 KB · xlsx file
Template 4:
School year calendar 2016/17 (UK)
landscape, year at a glance
- runs from 1 August 2016 to 31 July 2017
- one A4 page, landscape orientation (horizontal)
- years marked in different colours for easier identification
- UK edition with bank holidays highlighted in red
- with week numbers
- fully editable and customisable
Download template 41 page · 34 KB · xlsx file
School calendars 2016/17 UK for Microsoft Excel,
portrait orientation (3 templates)
Template 5:
School year calendar 2016/17 (UK)
portrait
- runs from 1 August 2016 to 31 July 2017
- one A4 page, portrait orientation (vertical)
- years marked in different colours for easier identification
- UK edition with bank holidays highlighted in red
- no week numbers
- fully editable and customisable
Download template 51 page · 32 KB · xlsx file
Template 6:
School year calendar 2016/17 (UK)
portrait, year at a glance
- runs from 1 August 2016 to 31 July 2017
- one A4 page, portrait orientation (vertical)
- years marked in different colours for easier identification
- UK edition with bank holidays highlighted in red
- with week numbers
- fully editable and customisable
Download template 61 page · 32 KB · xlsx file
Template 7:
School year calendar 2016/17 (UK)
portrait, continuous (rolling) layout
- runs from 1 August 2016 to 31 July 2017
- one A4 page, portrait orientation (vertical)
- years marked in different colours for easier identification
- days of the week arranged in columns - good for planning repeating events
- UK edition with bank holidays highlighted in red
- with week numbers
- fully editable and customisable
Download template 71 page · 31 KB · xlsx file
Key dates for the school year 2016/17
At a glance
These calendars run from Monday 1 August 2016 to Monday 31 July 2017: 365 days, 253 of them working days in England and Wales (Monday to Friday, not counting bank holidays). The period runs from week 31, the week commencing (w/c) Monday 1 August 2016, to week 31, w/c Monday 31 July 2017.
These calendars run from Monday 1 August 2016 to Monday 31 July 2017: 365 days, 253 of them working days in England and Wales (Monday to Friday, not counting bank holidays). The period runs from week 31, the week commencing (w/c) Monday 1 August 2016, to week 31, w/c Monday 31 July 2017.
Bank holidays in England and Wales
There are eight bank holidays in this period; a bank holiday that falls at the weekend is listed under its substitute day, the weekday on which it is taken:
There are eight bank holidays in this period; a bank holiday that falls at the weekend is listed under its substitute day, the weekday on which it is taken:
- Monday 29 August 2016: August Bank Holiday
- Monday 26 December 2016: Boxing Day
- Tuesday 27 December 2016: Christmas Day (substitute day)
- Monday 2 January 2017: New Year's Day (substitute day)
- Friday 14 April 2017: Good Friday
- Monday 17 April 2017: Easter Monday
- Monday 1 May 2017: Early May Bank Holiday
- Monday 29 May 2017: Spring Bank Holiday
- August Bank Holiday: Saturday 27 to Monday 29 August 2016 (three days)
- Christmas Day and Boxing Day: Saturday 24 to Tuesday 27 December 2016 (four days)
- New Year's Day: Saturday 31 December 2016 to Monday 2 January 2017 (three days)
- Good Friday and Easter Monday: Friday 14 to Monday 17 April 2017 (four days)
- Early May Bank Holiday: Saturday 29 April to Monday 1 May 2017 (three days)
- Spring Bank Holiday: Saturday 27 to Monday 29 May 2017 (three days)
Clock changes
The clocks go back one hour at 2am on Sunday 30 October 2016, when British Summer Time ends, and go forward one hour at 1am on Sunday 26 March 2017, when British Summer Time begins.
The clocks go back one hour at 2am on Sunday 30 October 2016, when British Summer Time ends, and go forward one hour at 1am on Sunday 26 March 2017, when British Summer Time begins.
Other dates to remember
Also in this period: Halloween on Monday 31 October 2016, Christmas Eve on Saturday 24 December 2016, New Year's Eve on Saturday 31 December 2016, Valentine's Day on Tuesday 14 February 2017, Mother's Day (Mothering Sunday) on Sunday 26 March 2017 and Father's Day on Sunday 18 June 2017.
Also in this period: Halloween on Monday 31 October 2016, Christmas Eve on Saturday 24 December 2016, New Year's Eve on Saturday 31 December 2016, Valentine's Day on Tuesday 14 February 2017, Mother's Day (Mothering Sunday) on Sunday 26 March 2017 and Father's Day on Sunday 18 June 2017.
School terms
In England and Wales the school year usually starts in early September and ends in mid to late July, with three terms and a half-term break in each. Term dates are set by local councils, academy trusts, school governing bodies and independent schools, so they vary - check your own school's dates (our FAQ explains where to find them). In Scotland the school year starts in mid-August, and in Northern Ireland it ends at the end of June. Because these calendars run from August to July, they cover the Scottish school year from its first day as well.
In England and Wales the school year usually starts in early September and ends in mid to late July, with three terms and a half-term break in each. Term dates are set by local councils, academy trusts, school governing bodies and independent schools, so they vary - check your own school's dates (our FAQ explains where to find them). In Scotland the school year starts in mid-August, and in Northern Ireland it ends at the end of June. Because these calendars run from August to July, they cover the Scottish school year from its first day as well.
School holidays 2016/17 in England
Schools in England usually have one week off at the end of October, two weeks over Christmas and New Year, one week in mid-February, two weeks around Easter or in early April, one week at the end of May and about six weeks in the summer. Academies, free schools, church schools and independent schools often set their own dates, and Wales, Scotland and Northern Ireland have their own school holidays, so check with your school or look up your council's dates on gov.uk. You can then mark them in your school calendar before printing it.
Schools in England usually have one week off at the end of October, two weeks over Christmas and New Year, one week in mid-February, two weeks around Easter or in early April, one week at the end of May and about six weeks in the summer. Academies, free schools, church schools and independent schools often set their own dates, and Wales, Scotland and Northern Ireland have their own school holidays, so check with your school or look up your council's dates on gov.uk. You can then mark them in your school calendar before printing it.
Ideas for your 2016/17 school calendar in Excel
Colour-coding terms and events
Give the autumn, spring and summer terms a light fill colour each, the half terms and holidays a stronger one, and INSET days, exams and trips colours of their own. Format Painter copies a colour from one block of days to the next, and a short key in an empty cell explains the colours to staff and parents.
Give the autumn, spring and summer terms a light fill colour each, the half terms and holidays a stronger one, and INSET days, exams and trips colours of their own. Format Painter copies a colour from one block of days to the next, and a short key in an empty cell explains the colours to staff and parents.
A copy for every class or department
Right-click the sheet tab, choose Move or Copy and tick "Create a copy" to give each class, year group or department its own copy of the school calendar in the same workbook. Keep a second worksheet listing assessments, trips and events with the date, the group and the member of staff responsible, and Sort & Filter puts them in date order or shows one class at a time.
Right-click the sheet tab, choose Move or Copy and tick "Create a copy" to give each class, year group or department its own copy of the school calendar in the same workbook. Keep a second worksheet listing assessments, trips and events with the date, the group and the member of staff responsible, and Sort & Filter puts them in date order or shows one class at a time.
Using the templates
Terms of Use
All templates on this site may be used free of charge, at home, at work and at school, provided that the Calendarpedia logo, the copyright notice with the website address ("© Calendarpedia® www.calendarpedia.co.uk") and the disclaimer ("Data provided 'as is' without warranty") stay on the template. The templates may not be sold or built into products that are sold, and the blank templates (or copies with only minor changes) may not be offered for download on other websites. All content on this site is protected by copyright © 2011-2026 Calendarpedia®. All rights reserved. Data is provided 'as is' without warranty of any kind, may contain errors and is subject to change without notice. If you find a mistake, please let us know. Full details are in our Terms of Use.
System requirements and compatibility
Every template is saved in Microsoft Excel (.xlsx) format, the Office Open XML spreadsheet format standardised as ISO/IEC 29500, which Excel has used since Excel 2007.
- Microsoft Excel
The templates open in Excel 2007 and later for Windows, Excel 2008 and later for Mac, Microsoft 365 and Excel for the web. - Google Sheets
The .xlsx files open in Google Sheets with the layout intact, so you can fill the template in from a browser on any computer, tablet or phone without installing anything. - Free alternatives
If you don't have Microsoft Excel installed, use Excel for the web (Microsoft 365 for the web, formerly Office Online, free with a Microsoft account) or one of the free alternatives to Microsoft Office: LibreOffice Calc or FreeOffice PlanMaker (and others). Apple's Numbers opens the files too, but the layout may shift, and OpenOffice Calc unfortunately has formatting problems with some of our calendars. - Editing on a phone or tablet
The Excel app for iPhone, iPad and Android and the Google Sheets app both open these files, so you can add or check an entry on the move and print the template later from any computer. - Your own dates, colours and logo
Type your entries straight into the day cells, shade the days that matter to you and add your own logo alongside the Calendarpedia logo - our FAQ shows how to add your own dates, colours or logo. - Printing in black and white
To save colour ink, you can print any template in black and white. - Older versions of Excel
Excel 2003 and older versions can't open .xlsx files directly. Open the template in Excel for the web or one of the free programs above instead, or use the PDF version of the calendar.
How to open and print these templates in Google Sheets
Download the .xlsx file first. Then either drag it into Google Drive, right-click it and choose Open with → Google Sheets, or open Sheets and go to File → Open → Upload. The template keeps its layout and colours, and you can type into the day cells and change the fill colours exactly as you would in Excel.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
Problems downloading, opening or printing a template?
Our FAQ explains how to print a template in a different size or in black and white, what to do if the edges are cut off, a download doesn't work or a file won't open in Excel or Word, which other programs you can use and how to add your own dates, colours or logo.






