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
Download 7 free school calendar templates for 2016/17 in Microsoft Excel format (.xlsx), made for the UK. They run from 1 August 2016 to 31 July 2017, so the whole school year - from the summer holidays before the autumn term to the end of the summer term - fits into one calendar. Every template marks the bank holidays for England and Wales, and most layouts show week numbers. No registration or email sign-up needed.
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)

Change to:  PDF (.pdf)   ·   Word (.docx)   
Download template 1: school year calendar 2016/17 (UK) for Microsoft Excel, landscape orientation, 1 page
landscape, 1 page

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
Download template 2: school year calendar 2016/17 (UK) for Microsoft Excel, landscape orientation, 2 pages
landscape, 2 pages

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
Download template 3: school year calendar 2016/17 (UK) for Microsoft Excel, landscape orientation, 1 page, linear
landscape, 1 page, linear

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
Download template 4: school year calendar 2016/17 (UK) for Microsoft Excel, landscape orientation, 1 page, year at a glance
landscape, 1 page, year at a glance

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)

Change to:  PDF (.pdf)   ·   Word (.docx)   
Download template 5: school year calendar 2016/17 (UK) for Microsoft Excel, portrait orientation, 1 page
portrait, 1 page

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
Download template 6: school year calendar 2016/17 (UK) for Microsoft Excel, portrait orientation, 1 page, year at a glance
portrait, 1 page, year at a glance

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
Download template 7: school year calendar 2016/17 (UK) for Microsoft Excel, portrait orientation, 1 page, days in continuous (rolling) layout
portrait, 1 page, continuous (rolling) layout

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.
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:
  • 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
They give you six long weekends without taking any annual leave:
  • 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)
Scotland and Northern Ireland have some different bank holidays - see bank holidays 2016 and bank holidays 2017.
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.
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.
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.
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.

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.
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.

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.

Problems downloading, opening or printing a template?