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
Download 5 free split year calendar templates for 2017/18 in Microsoft Excel format (.xlsx), made for the UK. They run from 1 July 2017 to 30 June 2018, so the second half of 2017 and the first half of 2018 fit into one calendar - ideal for seasons, projects and plans that run across the turn of the year. 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 from July 2017 to June 2018 are listed below the templates.

Split year calendars 2017/18 for Microsoft Excel,
landscape orientation (3 templates)

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

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
Download template 2: split year calendar 2017/18 (UK) for Microsoft Excel, landscape orientation, 1 page, linear
landscape, 1 page, linear

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
Download template 3: split year calendar 2017/18 (UK) for Microsoft Excel, landscape orientation, 1 page, year at a glance
landscape, 1 page, year at a glance

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)

Change to:  PDF (.pdf)   ·   Word (.docx)   
Download template 4: split year calendar 2017/18 (UK) for Microsoft Excel, portrait orientation, 1 page
portrait, 1 page

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
Download template 5: split year calendar 2017/18 (UK) for Microsoft Excel, portrait orientation, 1 page, year at a glance
portrait, 1 page, year at a glance

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

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

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?