Three year calendars 2013 / 2014 / 2015 (UK)
for Microsoft Excel
Free printable three year calendars
for years 2013, 2014 and 2015 in Excel file format
Advertisement
The number of bank holidays, the substitute days, Easter, British Summer Time and the working days of 2013, 2014 and 2015 are compared in a table below the templates, together with the bank holiday dates of each year and ideas for planning ahead.
Three year calendars 2013-15 (UK) for Microsoft Excel,
landscape orientation (2 templates)
Template 1:
Three year calendar 2013/14/15 (UK)
landscape, in colour
- runs from 1 January 2013 to 31 December 2015
- three years on one A4 page, arranged side by side
- landscape orientation (horizontal)
- in "rainbow" colour scheme that reflects the changing of the seasons
- each month shaded in a different colour that visually separates and distinguishes it for easy recognition and navigation
- makes it easy to scan the year while still reading each month independently
- UK edition with bank holidays highlighted in red
- fully editable and customisable
Download template 11 page · 24 KB · xlsx file
Template 2:
Three year calendar 2013/14/15 (UK)
landscape
- three year calendar from 1 January 2013 to 31 December 2015 on one A4 page, landscape orientation (horizontal)
- 2013, 2014 and 2015 side by side, each year in six rows of two months - all 36 months at a glance
- every month a small grid from Monday to Sunday, with a week number column on the left
- Saturdays shaded pale yellow, Sundays pale orange - Calendarpedia's classic standard design
- UK edition with the England and Wales bank holidays highlighted in red and listed with their dates beneath each year, substitute days included
- clear and uncluttered - good for contract terms, renewals and deadlines over three years
- fully editable and customisable
Download template 21 page · 25 KB · xlsx file
Three year calendars 2013-15 (UK) for Microsoft Excel,
portrait orientation (2 templates)
Template 3:
Three year calendar 2013/14/15 (UK)
portrait, in colour
- runs from 1 January 2013 to 31 December 2015
- three years on one A4 page, arranged on top of each other
- portrait orientation (vertical)
- in "rainbow" colour scheme that reflects the changing of the seasons
- each month shaded in a different colour that visually separates and distinguishes it for easy recognition and navigation
- makes it easy to scan the year while still reading each month independently
- UK edition with bank holidays highlighted in red
- fully editable and customisable
Download template 31 page · 39 KB · xlsx file
Template 4:
Three year calendar 2013/14/15 (UK)
portrait orientation
- three year calendar from 1 January 2013 to 31 December 2015 on one A4 page, portrait orientation (vertical)
- 2013, 2014 and 2015 one below the other, each year in three rows of four months - all 36 months at a glance
- every month a small grid from Monday to Sunday, with a week number column on the left
- Saturdays shaded pale yellow, Sundays pale orange - Calendarpedia's classic standard design
- UK edition with the England and Wales bank holidays highlighted in red and listed with their dates beneath each year, substitute days included
- clear and uncluttered - good for a folder, a desk or a fridge door
- fully editable and customisable
Download template 41 page · 40 KB · xlsx file
Key dates 2013-2015 at a glance
Key figures for each year
| 2013 | 2014 | 2015 | |
|---|---|---|---|
| Bank holidays in England and Wales | 8 | 8 | 8 |
| Substitute days | none | none | Mon 28 Dec |
| Easter Sunday | 31 March | 20 April | 5 April |
| British Summer Time | 31 Mar to 27 Oct | 30 Mar to 26 Oct | 29 Mar to 25 Oct |
| Working days in England and Wales | 253 | 253 | 253 |
| Weeks (ISO week numbers) | 52 | 52 | 53 |
| Days | 365 | 365 | 365 |
Good to know
The templates mark the bank holidays for England and Wales. A substitute day is the weekday on which a bank holiday is taken when its date falls at the weekend. Working days are Monday to Friday, not counting bank holidays. British Summer Time begins at 1am on the last Sunday in March and ends at 2am on the last Sunday in October. A year has 53 ISO weeks when it starts on a Thursday, or on a Wednesday in a leap year. Scotland and Northern Ireland have some different bank holidays - see bank holidays 2013, bank holidays 2014 and bank holidays 2015.
The templates mark the bank holidays for England and Wales. A substitute day is the weekday on which a bank holiday is taken when its date falls at the weekend. Working days are Monday to Friday, not counting bank holidays. British Summer Time begins at 1am on the last Sunday in March and ends at 2am on the last Sunday in October. A year has 53 ISO weeks when it starts on a Thursday, or on a Wednesday in a leap year. Scotland and Northern Ireland have some different bank holidays - see bank holidays 2013, bank holidays 2014 and bank holidays 2015.
Bank holidays 2013, 2014 and 2015 in England and Wales
2013
Tuesday 1 January: New Year's Day
Friday 29 March: Good Friday
Monday 1 April: Easter Monday
Monday 6 May: Early May Bank Holiday
Monday 27 May: Spring Bank Holiday
Monday 26 August: August Bank Holiday
Wednesday 25 December: Christmas Day
Thursday 26 December: Boxing Day
Tuesday 1 January: New Year's Day
Friday 29 March: Good Friday
Monday 1 April: Easter Monday
Monday 6 May: Early May Bank Holiday
Monday 27 May: Spring Bank Holiday
Monday 26 August: August Bank Holiday
Wednesday 25 December: Christmas Day
Thursday 26 December: Boxing Day
2014
Wednesday 1 January: New Year's Day
Friday 18 April: Good Friday
Monday 21 April: Easter Monday
Monday 5 May: Early May Bank Holiday
Monday 26 May: Spring Bank Holiday
Monday 25 August: August Bank Holiday
Thursday 25 December: Christmas Day
Friday 26 December: Boxing Day
Wednesday 1 January: New Year's Day
Friday 18 April: Good Friday
Monday 21 April: Easter Monday
Monday 5 May: Early May Bank Holiday
Monday 26 May: Spring Bank Holiday
Monday 25 August: August Bank Holiday
Thursday 25 December: Christmas Day
Friday 26 December: Boxing Day
2015
Thursday 1 January: New Year's Day
Friday 3 April: Good Friday
Monday 6 April: Easter Monday
Monday 4 May: Early May Bank Holiday
Monday 25 May: Spring Bank Holiday
Monday 31 August: August Bank Holiday
Friday 25 December: Christmas Day
Monday 28 December: Boxing Day (substitute day)
Thursday 1 January: New Year's Day
Friday 3 April: Good Friday
Monday 6 April: Easter Monday
Monday 4 May: Early May Bank Holiday
Monday 25 May: Spring Bank Holiday
Monday 31 August: August Bank Holiday
Friday 25 December: Christmas Day
Monday 28 December: Boxing Day (substitute day)
From one year to the next
Easter Sunday falls on 20 April in 2014, 20 days later in the year than in 2013, so the Easter bank holidays move with it. Easter Sunday falls on 5 April in 2015, 15 days earlier in the year than in 2014. 2013 starts on a Tuesday and has the same dates and days of the week as 2002 and 2019. 2014 starts on a Wednesday and has the same dates and days of the week as 2003 and 2025. 2015 starts on a Thursday and has the same dates and days of the week as 2009 and 2026. Only the weekdays repeat, though: Easter and the bank holidays that depend on it fall on different dates.
Easter Sunday falls on 20 April in 2014, 20 days later in the year than in 2013, so the Easter bank holidays move with it. Easter Sunday falls on 5 April in 2015, 15 days earlier in the year than in 2014. 2013 starts on a Tuesday and has the same dates and days of the week as 2002 and 2019. 2014 starts on a Wednesday and has the same dates and days of the week as 2003 and 2025. 2015 starts on a Thursday and has the same dates and days of the week as 2009 and 2026. Only the weekdays repeat, though: Easter and the bank holidays that depend on it fall on different dates.
Planning across three years
Plans that run past 31 December
A three year calendar shows 36 months on one page, so plans that run on into the next year stay in one view: a building project or a house move, a wedding planned a year or more ahead, a fixed-term contract or a tenancy, a pregnancy and the baby's first months, or a training plan for a marathon, and longer timelines such as a three-year degree, a mortgage fix or a business plan.
A three year calendar shows 36 months on one page, so plans that run on into the next year stay in one view: a building project or a house move, a wedding planned a year or more ahead, a fixed-term contract or a tenancy, a pregnancy and the baby's first months, or a training plan for a marathon, and longer timelines such as a three-year degree, a mortgage fix or a business plan.
Comparing the years
With the years side by side or one above the other, it is easy to see how the same month looks in each year: on which weekday a birthday or an anniversary falls, when the Easter holidays come round, or how many working days a month has. That makes the calendar useful for setting dates for repeat events, such as an annual conference, a club tournament or a family get-together.
With the years side by side or one above the other, it is easy to see how the same month looks in each year: on which weekday a birthday or an anniversary falls, when the Easter holidays come round, or how many working days a month has. That makes the calendar useful for setting dates for repeat events, such as an annual conference, a club tournament or a family get-together.
Deadlines and renewals
Mark the dates that come up once a year or less: MOT and insurance renewals, the end of a phone contract, passport and driving licence expiry, Self Assessment deadlines (31 January for online returns), or the end of a warranty. On a three year calendar you see them early enough to act in good time.
Mark the dates that come up once a year or less: MOT and insurance renewals, the end of a phone contract, passport and driving licence expiry, Self Assessment deadlines (31 January for online returns), or the end of a warranty. On a three year calendar you see them early enough to act in good time.
Ideas for your three-year calendar 2013-2015 in Excel
Colour-code projects across the years
Give each project, contract or phase its own fill colour and shade the days it runs from one year into the next, and the overlaps show straight away. Format Painter copies a colour from one run of days to the next, and a short key in an empty cell explains the colours.
Give each project, contract or phase its own fill colour and shade the days it runs from one year into the next, and the overlaps show straight away. Format Painter copies a colour from one run of days to the next, and a short key in an empty cell explains the colours.
A copy per team and a list of milestones
Right-click the sheet tab, choose Move or Copy and tick "Create a copy" to give each team or project its own three-year calendar in the same workbook. Keep a second worksheet listing milestones and renewals with the date, the project and the person responsible, and Sort & Filter puts them in date order or shows one project at a time.
Right-click the sheet tab, choose Move or Copy and tick "Create a copy" to give each team or project its own three-year calendar in the same workbook. Keep a second worksheet listing milestones and renewals with the date, the project and the person responsible, and Sort & Filter puts them in date order or shows one project 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.



