The Academic Calendar Portrait Template is a free Microsoft Excel workbook for schools, colleges, and educational institutions that need a printable academic year calendar in portrait format. It covers up to 14 consecutive months across 15 individual sheets. Three configuration inputs — Year, Start Month, and Start Day — control every sheet simultaneously. Change any one of them and the entire workbook updates in a single step.
The portrait layout is the key distinction of this template. Each monthly sheet is oriented vertically, fitting naturally on standard A4 or US letter paper without any page-setup adjustment. This makes it the preferred format for notice boards, filing folders, and printed handbooks, where portrait pages are easier to store and display than landscape pages. Furthermore, the template carries the school’s name automatically across all 14 monthly sheets from a single entry on the control sheet.
How Does the Portrait Layout Differ from Landscape?
The portrait orientation stacks the seven day columns vertically within each printed page, producing a taller, narrower monthly grid compared to a landscape layout. Each column is somewhat narrower, but the overall page uses familiar portrait proportions that match standard letter-head documents, student planners, and parent newsletters.
This format is consequently a better fit for documents that will be bound, stapled, or inserted into folders. It is also more practical for wall mounting in corridors or classrooms, where portrait sheets hang more naturally from a single pin or clip. In contrast, a landscape calendar requires a wider horizontal space to display clearly. Schools that produce printed academic planners or hand out monthly pages to students or parents will therefore find the portrait format more convenient.
What Are the Configuration Inputs?
All 15 sheets are governed by three inputs on Sheet 1. Each input has a precise effect on the entire workbook.
The Year Input
The Year input sets the starting year for the calendar. The default value is 2026. Changing it updates all month headers, all date placements, and all formula-driven holiday dates across every sheet instantly. No individual sheet requires any further editing.
The Start Month Input
The Start Month input sets which month appears first on Sheet 1. The default value is 7, corresponding to July. This default reflects the common North American academic calendar structure, where the school year begins in late July or August. Each subsequent sheet adds 1 to the start month automatically, so the calendar progresses in order through up to 14 consecutive months.
Setting this input to 8 starts the calendar from August. Setting it to 9 starts it from September, which suits academic calendars in the United Kingdom, Australia, and many other countries. The template therefore adapts to any institution’s academic year start without any formula editing.
The Start Day Input
The Start Day input controls whether weeks begin on Sunday (enter 1) or Monday (enter 2). All seven day-of-week column headers and all date placements across every monthly sheet shift accordingly. This makes the template suitable for institutions in both Sunday-start and Monday-start countries.
How Does the School Name Work?
The control sheet contains a placeholder in row 5 that reads “[Name of School] Academic Calendar”. Simply replace this text with the school’s name. Every subsequent monthly sheet references this cell directly. As a result, all 14 printed pages carry the correct school name in the header without any further editing. This is particularly valuable when producing printed calendars for distribution to staff, students, or parents, since consistent branding appears automatically across the full document.
How Do Events Appear on Each Monthly Sheet?
Each monthly sheet uses INDEX/MATCH formulas to look up the Events sheet and display up to 3 events per day. Three separate rows beneath each date number check columns G, H, and I of the Events sheet in sequence. If any event date matches the day’s date, the event name appears automatically in the correct position within the day column.
Why Three Events Per Day Matters for Schools
Academic calendars frequently require multiple entries on a single date. A public holiday might coincide with a term end date. A sports event might fall on the same day as a staff meeting. The three-event capacity handles these overlaps without any manual layout adjustment. Furthermore, the duplicate-detection logic in the Events sheet prevents the same holiday from appearing twice on a day, even when it is stored in multiple rows to cover consecutive academic years.
Adding Custom Events
Custom events are easy to add directly to the Events sheet. Enter the event name in column A and the date in column G. Copy the formulas in columns H and I from an existing row downward to preserve the duplicate-detection logic. The monthly sheets then display the custom event automatically on the correct date across all affected sheets.
What Holidays Are Pre-Loaded in the Events Sheet?
The Events sheet contains formula-calculated dates for a comprehensive set of US public holidays and observances. All floating holidays recalculate automatically when the Year input changes, so no manual date updates are ever required for recurring holidays.
Floating Federal Holidays
The following federal holidays recalculate from the year input using standard formula rules. Martin Luther King Jr. Day falls on the third Monday in January. Presidents’ Day falls on the third Monday in February. Memorial Day falls on the last Monday in May. Labor Day falls on the first Monday in September. Columbus Day falls on the second Monday in October. Thanksgiving falls on the fourth Thursday in November. Each of these dates updates automatically every year with no manual input.
Observances and Family Days
In addition to federal holidays, the Events sheet includes Mother’s Day (second Sunday in May), Armed Forces Day (third Saturday in May), Father’s Day (third Sunday in June), and Parents’ Day (fourth Sunday in July). These observances similarly recalculate with the year. Consequently, schools can rely on the template’s holiday list to be accurate year after year without any verification or correction.
Customising the Holiday List
Schools can remove any pre-built holiday by deleting its row from the Events sheet. They can also replace it with a locally relevant observance. Because the Events sheet uses a named range reference tied to Sheet 1’s year input, any custom holiday entered with a formula-based date will also update automatically when the year changes, provided the formula references the same year cell.
How Do You Print and Export to PDF?
The template includes embedded PDF export instructions on the control sheet. First, right-click the Events sheet tab and select Hide. Next, go to File, then Print. Select PDF as the printer type. Under Settings, choose “Print Entire Workbook”. This exports all 14 monthly portrait sheets as a single, multi-page PDF. The Events sheet is excluded because it was hidden in the previous step.
Because each sheet is already formatted for portrait printing, the output requires no additional page-setup work. The result is a clean, professional academic year calendar in PDF form, ready to share digitally or send to a printer for physical distribution.
How Do You Change the Colour Scheme?
The template supports colour scheme customisation through Excel’s theme system. Go to Page Layout, select Themes or Colors, and browse the available options. Choosing a theme colour set updates all formatted cells across every monthly sheet simultaneously. As a result, a single selection re-brands the entire 14-sheet workbook to match the school’s colours in one step.
Who Should Use This Template?
School administrators preparing printed academic year planners for staff and students will find the portrait format ideal for binding and distribution. The consistent school name header across all pages gives the finished document a professional, branded appearance.
Primary and secondary school offices that pin monthly calendars on notice boards will prefer portrait sheets, which hang more naturally and are easier to read at eye level than wide landscape pages.
College and university departments on semester or trimester schedules can set the Start Month to align with their institution’s term dates — September for UK and Australian universities, or August for many US colleges — and the calendar adjusts immediately.
HR teams in educational settings managing teacher contracts, training days, and appraisal periods will use the formula-driven holiday list to avoid manually entering public holiday dates each year, saving time and reducing the risk of errors.
Individual teachers who want a simple monthly planner with holidays already populated will be ready to print after entering the year and start month. Custom events such as assessment deadlines, field trips, or parent evenings can be added to the Events sheet in minutes.
How to Set Up the Template
Open the workbook in Excel. On Sheet 1, replace the school name placeholder with the institution’s name. Enter the Year in cell D3. Enter the Start Month in cell H3 — use 7 for July, 8 for August, or 9 for September depending on the academic year convention. Enter 1 in cell L3 for a Sunday start, or 2 for a Monday start. All 14 monthly sheets update instantly.
Next, open the Events sheet to review the pre-loaded holidays. Add any school-specific dates by entering the event name in column A and the date in column G, then copying the H and I formulas downward.
Finally, to export as PDF, hide the Events sheet, go to File, select Print, choose PDF as the printer, and select Print Entire Workbook. The complete 14-month portrait calendar exports in one step.
Conclusion
The Academic Calendar Portrait Template is a fully formula-driven Excel workbook for schools and educational institutions that need a vertical-format academic year calendar. It covers up to 14 months from any configurable start point, with a default July start suited to North American academic calendars. Each sheet displays up to 3 auto-populated events per day from the built-in Events sheet. Formula-calculated US public holidays require no manual updates. The school name, colour scheme, and start month are all customisable from a single control sheet. Download it today and produce a print-ready academic year calendar in minutes.