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
Download 6 free three year calendar templates for 2028, 2029 and 2030 in Microsoft Excel format (.xlsx), made for the UK. Each one shows all 36 months from 1 January 2028 to 31 December 2030 on a single A4 page, with week numbers and the bank holidays for England and Wales - ideal for long-term plans, multi-year projects and anything you need to see three years ahead. No registration or email sign-up needed.

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.
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.
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.
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.
The number of bank holidays, the substitute days, Easter, British Summer Time and the working days of 2028, 2029 and 2030 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 2028-30 (UK) for Microsoft Excel,
landscape orientation (3 templates)

Change to:  PDF (.pdf)   ·   Word (.docx)   
View large imageDownload template 1: Excel template for three year calendar 2028-2030 in colour (landscape orientation, 1 page, A4)
landscape, 1 page,
in colour

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
View large imageDownload template 2: Excel template for three year calendar 2028-2030 in blue/red (landscape orientation, 1 page, A4)
landscape, 1 page,
blue/red

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
View large imageDownload template 3: Excel template for three year calendar 2028-2030 (landscape orientation, 1 page, A4)
landscape, 1 page

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)

Change to:  PDF (.pdf)   ·   Word (.docx)   
View large imageDownload template 4: Excel template for three year calendar 2028-2030 in colour (portrait orientation, 1 page, A4)
portrait, 1 page,
in colour

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
View large imageDownload template 5: Excel template for three year calendar 2028-2030 in blue/red (portrait orientation, 1 page, A4)
portrait, 1 page,
blue/red

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
View large imageDownload template 6: Excel template for three year calendar 2028-2030 (portrait orientation, 1 page, A4)
portrait, 1 page

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

202820292030
Bank holidays in England and Wales888
Substitute daysMon 3 Jannonenone
Easter Sunday16 April1 April21 April
British Summer Time26 Mar to 29 Oct25 Mar to 28 Oct31 Mar to 27 Oct
Working days in England and Wales252253253
Weeks (ISO week numbers)525252
Days366 (leap year)365365
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.

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

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

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

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?