Split year calendars 2017/2018 (UK)
for Microsoft Excel
Split year calendar templates for years
2017 and 2018 (UK) in Microsoft Excel file format
Advertisement
The bank holidays, clock changes and working days from July 2017 to June 2018 are listed below the templates.
Split year calendars 2017/18 for Microsoft Excel,
landscape orientation (3 templates)
Template 1:
Split year calendar 2017/18 (UK)
landscape
- runs from 1 July 2017 to 30 June 2018
- one A4 page, landscape orientation (horizontal)
- second half of 2017 (July to December) and first half of 2018 (January to June) together on 1 page
- 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 · 30 KB · xlsx file
Template 2:
Split year calendar 2017/18 (UK)
landscape, linear
- runs from 1 July 2017 to 30 June 2018
- one A4 page, landscape orientation (horizontal)
- second half of 2017 (July to December) and first half of 2018 (January to June) together on 1 page
- 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 21 page · 25 KB · xlsx file
Template 3:
Split year calendar 2017/18 (UK)
landscape, year at a glance
- runs from 1 July 2017 to 30 June 2018
- one A4 page, landscape orientation (horizontal)
- second half of 2017 (July to December) and first half of 2018 (January to June) together on 1 page
- 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 · 24 KB · xlsx file
Split year calendars 2017/18 for Microsoft Excel,
portrait orientation (2 templates)
Template 4:
Split year calendar 2017/18 (UK)
portrait
- runs from 1 July 2017 to 30 June 2018
- one A4 page, portrait orientation (vertical)
- second half of 2017 (July to December) and first half of 2018 (January to June) together on 1 page
- 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 41 page · 23 KB · xlsx file
Template 5:
Split year calendar 2017/18 (UK)
portrait, year at a glance
- runs from 1 July 2017 to 30 June 2018
- one A4 page, portrait orientation (vertical)
- second half of 2017 (July to December) and first half of 2018 (January to June) together on 1 page
- 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 51 page · 24 KB · xlsx file
Key dates for the split year 2017/18
At a glance
These calendars run from Saturday 1 July 2017 to Saturday 30 June 2018: 365 days, 252 of them working days in England and Wales (Monday to Friday, not counting bank holidays). The period runs from week 26, the week commencing (w/c) Monday 26 June 2017, to week 26, w/c Monday 25 June 2018.
These calendars run from Saturday 1 July 2017 to Saturday 30 June 2018: 365 days, 252 of them working days in England and Wales (Monday to Friday, not counting bank holidays). The period runs from week 26, the week commencing (w/c) Monday 26 June 2017, to week 26, w/c Monday 25 June 2018.
Bank holidays in England and Wales
There are eight bank holidays in this period:
There are eight bank holidays in this period:
- Monday 28 August 2017: August Bank Holiday
- Monday 25 December 2017: Christmas Day
- Tuesday 26 December 2017: Boxing Day
- Monday 1 January 2018: New Year's Day
- Friday 30 March 2018: Good Friday
- Monday 2 April 2018: Easter Monday
- Monday 7 May 2018: Early May Bank Holiday
- Monday 28 May 2018: Spring Bank Holiday
- August Bank Holiday: Saturday 26 to Monday 28 August 2017 (three days)
- Christmas Day and Boxing Day: Saturday 23 to Tuesday 26 December 2017 (four days)
- New Year's Day: Saturday 30 December 2017 to Monday 1 January 2018 (three days)
- Good Friday and Easter Monday: Friday 30 March to Monday 2 April 2018 (four days)
- Early May Bank Holiday: Saturday 5 to Monday 7 May 2018 (three days)
- Spring Bank Holiday: Saturday 26 to Monday 28 May 2018 (three days)
Clock changes
The clocks go back one hour at 2am on Sunday 29 October 2017, when British Summer Time ends, and go forward one hour at 1am on Sunday 25 March 2018, when British Summer Time begins.
The clocks go back one hour at 2am on Sunday 29 October 2017, when British Summer Time ends, and go forward one hour at 1am on Sunday 25 March 2018, when British Summer Time begins.
Other dates to remember
Also in this period: Halloween on Tuesday 31 October 2017, Christmas Eve on Sunday 24 December 2017, New Year's Eve on Sunday 31 December 2017, Valentine's Day on Wednesday 14 February 2018, Mother's Day (Mothering Sunday) on Sunday 11 March 2018 and Father's Day on Sunday 17 June 2018.
Also in this period: Halloween on Tuesday 31 October 2017, Christmas Eve on Sunday 24 December 2017, New Year's Eve on Sunday 31 December 2017, Valentine's Day on Wednesday 14 February 2018, Mother's Day (Mothering Sunday) on Sunday 11 March 2018 and Father's Day on Sunday 17 June 2018.
Who uses a July to June year
A year from July to June suits plans that run across the summer and the turn of the year: sports seasons (the football season in England runs from August to May), club and society years, and organisations whose financial year ends on 30 June. It is also the financial year in Australia.
A year from July to June suits plans that run across the summer and the turn of the year: sports seasons (the football season in England runs from August to May), club and society years, and organisations whose financial year ends on 30 June. It is also the financial year in Australia.
Ideas for your 2017/18 split year calendar in Excel
Colour-coding teams, sections and events
Give each team, section or activity its own fill colour and shade its fixtures and meetings across the year, and clashes between them show straight away. Format Painter copies a colour from one day to the next, and a short key in an empty cell explains the colours to the committee.
Give each team, section or activity its own fill colour and shade its fixtures and meetings across the year, and clashes between them show straight away. Format Painter copies a colour from one day to the next, and a short key in an empty cell explains the colours to the committee.
A copy for every team and a list of fixtures
Right-click the sheet tab, choose Move or Copy and tick "Create a copy" to give each team or section its own July to June calendar in the same workbook. Keep a second worksheet listing fixtures and events with the date, the team and the venue, and Sort & Filter puts them in date order or shows one team at a time.
Right-click the sheet tab, choose Move or Copy and tick "Create a copy" to give each team or section its own July to June calendar in the same workbook. Keep a second worksheet listing fixtures and events with the date, the team and the venue, and Sort & Filter puts them in date order or shows one team 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.




