School calendars 2014/15 (UK)
in Excel format
Calendar templates for the UK school year 2014/15
in Microsoft Excel format to download, edit and print
Advertisement
The bank holidays, clock changes and working days of the school year 2014/15, 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 2014/15 UK for Microsoft Excel,
landscape orientation (4 templates)
Template 1:
School year calendar 2014/15 (UK)
landscape
- runs from 1 August 2014 to 31 July 2015
- 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 2014/15 (UK)
landscape, 2 pages
- runs from 1 August 2014 to 31 July 2015
- 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 · 41 KB · xlsx file
Template 3:
School year calendar 2014/15 (UK)
landscape, linear
- runs from 1 August 2014 to 31 July 2015
- 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 2014/15 (UK)
landscape, year at a glance
- runs from 1 August 2014 to 31 July 2015
- 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 2014/15 UK for Microsoft Excel,
portrait orientation (3 templates)
Template 5:
School year calendar 2014/15 (UK)
portrait
- runs from 1 August 2014 to 31 July 2015
- 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 2014/15 (UK)
portrait, year at a glance
- runs from 1 August 2014 to 31 July 2015
- 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 · 16 KB · xlsx file
Template 7:
School year calendar 2014/15 (UK)
portrait, continuous (rolling) layout
- runs from 1 August 2014 to 31 July 2015
- 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 2014/15
At a glance
These calendars run from Friday 1 August 2014 to Friday 31 July 2015: 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 28 July 2014, to week 31, w/c Monday 27 July 2015.
These calendars run from Friday 1 August 2014 to Friday 31 July 2015: 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 28 July 2014, to week 31, w/c Monday 27 July 2015.
Bank holidays in England and Wales
There are eight bank holidays in this period:
There are eight bank holidays in this period:
- Monday 25 August 2014: August Bank Holiday
- Thursday 25 December 2014: Christmas Day
- Friday 26 December 2014: Boxing Day
- Thursday 1 January 2015: New Year's Day
- Friday 3 April 2015: Good Friday
- Monday 6 April 2015: Easter Monday
- Monday 4 May 2015: Early May Bank Holiday
- Monday 25 May 2015: Spring Bank Holiday
- August Bank Holiday: Saturday 23 to Monday 25 August 2014 (three days)
- Christmas Day and Boxing Day: Thursday 25 to Sunday 28 December 2014 (four days)
- Good Friday and Easter Monday: Friday 3 to Monday 6 April 2015 (four days)
- Early May Bank Holiday: Saturday 2 to Monday 4 May 2015 (three days)
- Spring Bank Holiday: Saturday 23 to Monday 25 May 2015 (three days)
Clock changes
The clocks go back one hour at 2am on Sunday 26 October 2014, when British Summer Time ends, and go forward one hour at 1am on Sunday 29 March 2015, when British Summer Time begins.
The clocks go back one hour at 2am on Sunday 26 October 2014, when British Summer Time ends, and go forward one hour at 1am on Sunday 29 March 2015, when British Summer Time begins.
Other dates to remember
Also in this period: Halloween on Friday 31 October 2014, Christmas Eve on Wednesday 24 December 2014, New Year's Eve on Wednesday 31 December 2014, Valentine's Day on Saturday 14 February 2015, Mother's Day (Mothering Sunday) on Sunday 15 March 2015 and Father's Day on Sunday 21 June 2015.
Also in this period: Halloween on Friday 31 October 2014, Christmas Eve on Wednesday 24 December 2014, New Year's Eve on Wednesday 31 December 2014, Valentine's Day on Saturday 14 February 2015, Mother's Day (Mothering Sunday) on Sunday 15 March 2015 and Father's Day on Sunday 21 June 2015.
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 2014/15 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 2014/15 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.






