2028 calendar template for Excel
Looking further ahead? Here is the 2028 calendar as an Excel file. 2028 is a leap year, Easter falls in mid April, and the US or UK holidays are already marked.
In short: calendar-2028.xlsx is a 2028 calendar in Excel with week numbers, a notes column, a printable month sheet and the 2028 holidays for the US or the UK. The year sits in one cell and every date comes from DATE, so the same file works for any year.
Download the 2028 Excel calendar
The Year sheet shows all twelve months side by side with weekends in grey and holidays in red, each with its name. The Month sheet gives you one month with large boxes. Weeks start on Sunday with US week numbers, or on Monday with ISO week numbers, set once on the Year sheet. The Holidays sheet lists every date.
Enlarge previewDownload the finished template
The finished Excel file calendar-2028.xlsx, with sample rows and instructions, is free. All you need is a free account: no subscription, no payment details.
Create a free account and download the template Already have an account? Log in
2028 at a glance
- 2028 starts on a Saturday and ends on a Sunday.
- 2028 is a leap year with 366 days, so February has 29 days. The template handles February 29 by itself because DATE knows leap years.
- There are 52 ISO weeks; week 1 starts on Monday, January 3, 2028.
- Without weekends and the US federal holidays observed in 2028, there are 250 working days from Monday to Friday.
US federal holidays 2028
Dates are the days off for federal employees: a holiday on a Saturday is observed on the Friday before, one on a Sunday on the Monday after, as listed by the U.S. Office of Personnel Management.
| Date | Holiday |
|---|---|
| Friday, December 31, 2027 | New Year's Day |
| Monday, January 17, 2028 | Birthday of Martin Luther King, Jr. |
| Monday, February 21, 2028 | Washington's Birthday |
| Monday, May 29, 2028 | Memorial Day |
| Monday, June 19, 2028 | Juneteenth National Independence Day |
| Tuesday, July 4, 2028 | Independence Day |
| Monday, September 4, 2028 | Labor Day |
| Monday, October 9, 2028 | Columbus Day |
| Friday, November 10, 2028 | Veterans Day |
| Thursday, November 23, 2028 | Thanksgiving Day |
| Monday, December 25, 2028 | Christmas Day |
UK bank holidays 2028 (England and Wales)
When a bank holiday falls on a weekend, a substitute day follows on the next weekday, as published on GOV.UK. Scotland and Northern Ireland have some different days; add them to the Holidays sheet if you need them.
| Date | Bank holiday |
|---|---|
| Monday, January 3, 2028 | New Year's Day |
| Friday, April 14, 2028 | Good Friday |
| Monday, April 17, 2028 | Easter Monday |
| Monday, May 1, 2028 | Early May bank holiday |
| Monday, May 29, 2028 | Spring bank holiday |
| Monday, August 28, 2028 | Summer bank holiday |
| Monday, December 25, 2028 | Christmas Day |
| Tuesday, December 26, 2028 | Boxing Day |
Checked against opm.gov and gov.uk in November 2026. One-off extra holidays can be announced later, so check the official lists before you plan around a date.
Long weekends in 2028
8 US federal holidays and 7 bank holidays in England and Wales fall on a Monday or Friday in 2028, which gives a three-day weekend. These fall on a Tuesday or Thursday, so one extra day off makes four days in a row: Independence Day (US, Tuesday, July 4, 2028), Thanksgiving Day (US, Thursday, November 23, 2028).
Build the 2028 calendar yourself
The guide on how to make a calendar in Excel walks through the formulas behind this file: dates with DATE, weekends with WEEKDAY and conditional formatting, holidays with COUNTIF, and a month grid with SEQUENCE. You can practice each step in the browser.