Three year calendars 2028 / 2029 / 2030 (UK)
for Microsoft Excel
Free printable three year calendars
for years 2028, 2029 and 2030 in Excel file format
Advertisement
Find the right three year calendar for 2028-2030
Landscape or portrait
In the landscape templates 1, 2 and 3 the three years stand side by side, so you can compare the same month across all three years. In the portrait templates 4, 5 and 6 they are stacked, one year above the next.
In the landscape templates 1, 2 and 3 the three years stand side by side, so you can compare the same month across all three years. In the portrait templates 4, 5 and 6 they are stacked, one year above the next.
Colour schemes
Templates 1 and 4 are "rainbow calendars" with each month in its own colour. Templates 2 and 5 show Saturdays in blue and Sundays in red. Templates 3 and 6 have Calendarpedia's classic design, with pale yellow Saturdays, pale orange Sundays and bank holidays in pale red. To save colour ink, you can print any template in black and white.
Templates 1 and 4 are "rainbow calendars" with each month in its own colour. Templates 2 and 5 show Saturdays in blue and Sundays in red. Templates 3 and 6 have Calendarpedia's classic design, with pale yellow Saturdays, pale orange Sundays and bank holidays in pale red. To save colour ink, you can print any template in black and white.
Bank holidays and week numbers
Every template marks the bank holidays for England and Wales, including substitute days, lists them for each of the three years and shows week numbers. The bank holidays for 2028, 2029 and 2030 follow the usual rules for England and Wales. The official dates are usually confirmed about a year ahead, and we check the templates against the official list on GOV.UK as soon as they are published.
Every template marks the bank holidays for England and Wales, including substitute days, lists them for each of the three years and shows week numbers. The bank holidays for 2028, 2029 and 2030 follow the usual rules for England and Wales. The official dates are usually confirmed about a year ahead, and we check the templates against the official list on GOV.UK as soon as they are published.
Edit in Excel, then print
Colour in the days that matter to you, add notes or your own logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colours or logo), then print. The Excel calendar also opens in Google Sheets and LibreOffice Calc.
Colour in the days that matter to you, add notes or your own logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colours or logo), then print. The Excel calendar also opens in Google Sheets and LibreOffice Calc.
Three year calendars 2028-30 (UK) for Microsoft Excel,
landscape orientation (3 templates)
Template 1:
Three year calendar 2028/29/30 (UK)
landscape, in colour
- three year calendar from 1 January 2028 to 31 December 2030 on one A4 page, landscape orientation (horizontal)
- 2028, 2029 and 2030 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
- each month headed in its own colour ("rainbow calendar"), with Saturdays in blue and Sundays in red figures
- UK edition with the England and Wales bank holidays highlighted in red and listed with their dates beneath each year, substitute days included
- good for long-term plans over three years, such as a project, a course of study or a savings goal
- fully editable and customisable
Download template 11 page · 29 KB · xlsx file
Template 2:
Three year calendar 2028/29/30 (UK)
landscape, blue/red
- three year calendar from 1 January 2028 to 31 December 2030 on one A4 page, landscape orientation (horizontal)
- 2028, 2029 and 2030 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 in blue on a pale blue background, Sundays in red on a pale red background, so the weekends stand out
- UK edition with the England and Wales bank holidays highlighted in red and listed with their dates beneath each year, substitute days included
- good for planning holidays and annual leave several years ahead
- fully editable and customisable
Download template 21 page · 26 KB · xlsx file
Template 3:
Three year calendar 2028/29/30 (UK)
landscape
- three year calendar from 1 January 2028 to 31 December 2030 on one A4 page, landscape orientation (horizontal)
- 2028, 2029 and 2030 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 31 page · 26 KB · xlsx file
Three year calendars 2028-30 (UK) for Microsoft Excel,
portrait orientation (3 templates)
Template 4:
Three year calendar 2028/29/30 (UK)
portrait, in colour
- three year calendar from 1 January 2028 to 31 December 2030 on one A4 page, portrait orientation (vertical)
- 2028, 2029 and 2030 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
- each month headed in its own colour ("rainbow calendar"), with Saturdays in blue and Sundays in red figures
- UK edition with the England and Wales bank holidays highlighted in red and listed with their dates beneath each year, substitute days included
- good for a wall or noticeboard: three years of family dates, anniversaries and events on one sheet
- fully editable and customisable
Download template 41 page · 30 KB · xlsx file
Template 5:
Three year calendar 2028/29/30 (UK)
portrait, blue/red
- three year calendar from 1 January 2028 to 31 December 2030 on one A4 page, portrait orientation (vertical)
- 2028, 2029 and 2030 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 in blue on a pale blue background, Sundays in red on a pale red background, so the weekends stand out
- UK edition with the England and Wales bank holidays highlighted in red and listed with their dates beneath each year, substitute days included
- good for spotting long weekends and bank holiday clusters three years ahead
- fully editable and customisable
Download template 51 page · 27 KB · xlsx file
Template 6:
Three year calendar 2028/29/30 (UK)
portrait orientation
- three year calendar from 1 January 2028 to 31 December 2030 on one A4 page, portrait orientation (vertical)
- 2028, 2029 and 2030 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 61 page · 27 KB · xlsx file
Key dates 2028-2030 at a glance
Key figures for each year
| 2028 | 2029 | 2030 | |
|---|---|---|---|
| Bank holidays in England and Wales | 8 | 8 | 8 |
| Substitute days | Mon 3 Jan | none | none |
| Easter Sunday | 16 April | 1 April | 21 April |
| British Summer Time | 26 Mar to 29 Oct | 25 Mar to 28 Oct | 31 Mar to 27 Oct |
| Working days in England and Wales | 252 | 253 | 253 |
| Weeks (ISO week numbers) | 52 | 52 | 52 |
| Days | 366 (leap year) | 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 2028, bank holidays 2029 and bank holidays 2030.
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 2028, bank holidays 2029 and bank holidays 2030.
Bank holidays 2028, 2029 and 2030 in England and Wales
2028
Monday 3 January: New Year's Day (substitute day)
Friday 14 April: Good Friday
Monday 17 April: Easter Monday
Monday 1 May: Early May Bank Holiday
Monday 29 May: Spring Bank Holiday
Monday 28 August: August Bank Holiday
Monday 25 December: Christmas Day
Tuesday 26 December: Boxing Day
Monday 3 January: New Year's Day (substitute day)
Friday 14 April: Good Friday
Monday 17 April: Easter Monday
Monday 1 May: Early May Bank Holiday
Monday 29 May: Spring Bank Holiday
Monday 28 August: August Bank Holiday
Monday 25 December: Christmas Day
Tuesday 26 December: Boxing Day
2029
Monday 1 January: New Year's Day
Friday 30 March: Good Friday
Monday 2 April: Easter Monday
Monday 7 May: Early May Bank Holiday
Monday 28 May: Spring Bank Holiday
Monday 27 August: August Bank Holiday
Tuesday 25 December: Christmas Day
Wednesday 26 December: Boxing Day
Monday 1 January: New Year's Day
Friday 30 March: Good Friday
Monday 2 April: Easter Monday
Monday 7 May: Early May Bank Holiday
Monday 28 May: Spring Bank Holiday
Monday 27 August: August Bank Holiday
Tuesday 25 December: Christmas Day
Wednesday 26 December: Boxing Day
2030
Tuesday 1 January: New Year's Day
Friday 19 April: Good Friday
Monday 22 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 19 April: Good Friday
Monday 22 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
From one year to the next
Easter Sunday falls on 1 April in 2029, 15 days earlier in the year than in 2028, so the Easter bank holidays move with it. Easter Sunday falls on 21 April in 2030, 20 days later in the year than in 2029. 2028 is a leap year, with 29 February on a Tuesday. 2028 starts on a Saturday and has the same dates and days of the week as 2000 and 2056. 2029 starts on a Monday and has the same dates and days of the week as 2018 and 2035. 2030 starts on a Tuesday and has the same dates and days of the week as 2019 and 2041. Only the weekdays repeat, though: Easter and the bank holidays that depend on it fall on different dates.
Easter Sunday falls on 1 April in 2029, 15 days earlier in the year than in 2028, so the Easter bank holidays move with it. Easter Sunday falls on 21 April in 2030, 20 days later in the year than in 2029. 2028 is a leap year, with 29 February on a Tuesday. 2028 starts on a Saturday and has the same dates and days of the week as 2000 and 2056. 2029 starts on a Monday and has the same dates and days of the week as 2018 and 2035. 2030 starts on a Tuesday and has the same dates and days of the week as 2019 and 2041. 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 2028-2030 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.





