Split year calendars 2021/2022 (UK)
for Microsoft Excel

Split year calendar templates for years 2021 and 2022 (UK) in Microsoft Excel file format

Advertisement
Split year calendars covering the period July 1st, 2021 to June 30th, 2022 (2nd half 2021 and 1st half 2022 to view on a single sheet). Version for the United Kingdom with UK bank holidays. Years are marked in different colours for easy identification. Available in both landscape and portrait orientation. Use them as a mid-year to mid-year planner for dates, schedules and events, and for tracking proposals and projects. The calendars are easily customisable and modifiable, flexible, and simple to change and adjust, suitable for a large number of diverse uses, e.g. as an academic, semester and school year planner, hobby, club, society or community calendar, seasonal planner or agenda, holiday, travel, vacation or trip planner, academic, work or funding application process and progress tracker, planner for events, celebrations and special occasions, business calendar, non-standard year planner, desk calendar or wall planner, for project planning/project management, CRM, ERP/MRP, PLM, EMM, SCM, as team collaboration tool, time tracking and many more. Plan ahead and get organized with these bright, colourful and attractive split-year multi-purpose calendars and planners! The dates also correspond to the financial year dates in Australia and New Zealand.

Terms of Use

All templates on this site may be used free of charge, 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") are not removed. Not for commercial distribution or resale. 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.

Split year calendars 2021/22 for Microsoft Excel,
landscape orientation (4 templates)

Change to:  PDF (.pdf)   ·   Word (.docx)   
View large imageDownload template 1: split year calendar 2021/22 (UK) for Microsoft Excel, landscape orientation, 1 page
landscape, 1 page

Template 1:
Split year calendar 2021/22 (UK)
landscape

  • runs from July 1st, 2021 to June 30th, 2022
  • one A4 page, landscape orientation (horizontal)
  • second half of 2021 (July to December) and first half of 2022 (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
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 1
View large imageDownload template 2: split year calendar 2021/22 (UK) for Microsoft Excel, landscape orientation, 2 pages
landscape, 2 pages

Template 2:
Split year calendar 2021/22 (UK)
landscape, 2 pages

  • runs from July 1st, 2021 to June 30th, 2022
  • two A4 pages, landscape orientation (horizontal)
  • half a year (six months) per page
  • separate pages for the first and second half of the year
  • second half of 2021 (July to December) and first half of 2022 (January to June) on separate pages
  • years marked in different colours for easier identification
  • UK edition with bank holidays highlighted in  red 
  • with week numbers
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 2
View large imageDownload template 3: split year calendar 2021/22 (UK) for Microsoft Excel, landscape orientation, 1 page, linear
landscape, 1 page, linear

Template 3:
Split year calendar 2021/22 (UK)
landscape, linear

  • runs from July 1st, 2021 to June 30th, 2022
  • one A4 page, landscape orientation (horizontal)
  • second half of 2021 (July to December) and first half of 2022 (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
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 3
View large imageDownload template 4: split year calendar 2021/22 (UK) for Microsoft Excel, landscape orientation, 1 page, year at a glance
landscape, 1 page, year at a glance

Template 4:
Split year calendar 2021/22 (UK)
landscape, year at a glance

  • runs from July 1st, 2021 to June 30th, 2022
  • one A4 page, landscape orientation (horizontal)
  • second half of 2021 (July to December) and first half of 2022 (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
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 4

Split year calendars 2021/22 for Microsoft Excel,
portrait orientation (4 templates)

Change to:  PDF (.pdf)   ·   Word (.docx)   
View large imageDownload template 5: split year calendar 2021/22 (UK) for Microsoft Excel, portrait orientation, 1 page, divided into two half-year blocks
portrait, 1 page, two half-year blocks

Template 5:
Split year calendar 2021/22 (UK)
portrait, two half-year blocks

  • runs from July 1st, 2021 to June 30th, 2022
  • two half-year blocks on one A4 page, portrait orientation (vertical)
  • second half of 2021 (July to December) and first half of 2022 (January to June) together on 1 page
  • years marked in different colours for easier identification
  • UK edition with bank holidays highlighted in  red 
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 5
View large imageDownload template 6: split year calendar 2021/22 (UK) for Microsoft Excel, portrait orientation, 1 page
portrait, 1 page

Template 6:
Split year calendar 2021/22 (UK)
portrait

  • runs from July 1st, 2021 to June 30th, 2022
  • one A4 page, portrait orientation (vertical)
  • second half of 2021 (July to December) and first half of 2022 (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
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 6
View large imageDownload template 7: split year calendar 2021/22 (UK) for Microsoft Excel, portrait orientation, 1 page, year at a glance
portrait, 1 page, year at a glance

Template 7:
Split year calendar 2021/22 (UK)
portrait, year at a glance

  • runs from July 1st, 2021 to June 30th, 2022
  • one A4 page, portrait orientation (vertical)
  • second half of 2021 (July to December) and first half of 2022 (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
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 7
View large imageDownload template 8: split year calendar 2021/22 (UK) for Microsoft Excel, portrait orientation, 1 page, days in continuous (rolling) layout
portrait, 1 page, continuous (rolling) layout

Template 8:
Split year calendar 2021/22 (UK)
portrait, continuous (rolling) layout

  • runs from July 1st, 2021 to June 30th, 2022
  • one A4 page, portrait orientation (vertical)
  • second half of 2021 (July to December) and first half of 2022 (January to June) together on 1 page
  • 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
  • Microsoft Excel (.xlsx) file - fully editable and customisable

Download template 8

System Requirements and Flexibility

Each file is delivered in standard Microsoft Excel (.xlsx) format, adhering fully to universal XML document protocols.
  • Microsoft Ecosystem
    Fully optimised for Excel versions 2007 right through to 2024 across Windows, Mac, and mobile devices.
  • Open-Source and Free Platforms
    Enjoy flawless cross-compatibility with alternative suites without formatting errors. If you don't have Microsoft Excel installed, use Microsoft 365 (formerly Office Online) or one of the Microsoft Office alternatives FreeOffice PlanMaker, LibreOffice Calc, Google Sheets and others, which are all free of charge (OpenOffice Calc unfortunately has formatting problems when opening our calendars).
  • Older Software Versions
    If you are running legacy packages (such as Excel 2000, XP, or 2003), the templates can be easily converted via a file converter or accessed via browser-based office tools.

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