2022/23 Split Year Calendar:
8 free Excel templates
July 2022 to June 2023, one, two and four pages. For Excel and
Google Sheets. Free to download, edit and print, no sign-up.
Advertisement
A split year calendar cuts the year in the middle rather than at the end. These run July through June, so they show the second half of 2022 and the first half of 2023 on one sheet, with the change of calendar year falling in the middle instead of at the edge. That is the whole point of the format: if the twelve months you care about straddle New Year, a January-to-December calendar splits them across two sheets and a split year calendar does not.
July to June is a common span in the US. It is the fiscal year used by most state and local governments, by a great many nonprofits and school districts, and by plenty of membership organizations, clubs and sports leagues whose season runs across the winter. It is also the Australian financial year, which is why these sheets get used well outside the US as well.
The two calendar years are color-coded throughout: the 2022 months carry a green heading and the 2023 months a blue one. On a calendar built around a mid-year boundary that is not decoration - it is the fastest way to see which side of New Year a date falls on, and it makes the twelve months read as one span rather than two halves stuck together.
The days are left blank, because the dates that matter are yours. What is already on them is the part that does not vary: every date, every weekday and every US federal holiday for 2022-2023, shown on the day it is actually observed, so all you have to add is what is specific to your year.
How much you need to write in each day decides which layout to take. One page puts the whole split year in front of you at once, two pages give you six months per sheet, and four pages devote a quarter to each sheet with the largest day boxes of the set. Every one of those comes in both landscape and portrait, in classic grid, linear and rolling arrangements, with Saturdays shaded pale yellow, Sundays pale orange and federal holidays printed in red on pale pink, so working days stand out from the rest. Browse the templates below and choose the layout that fits how you want to map out 2022/23.
Free to download, editable, no sign-up
Every .xlsx file here is free to download and free to use, with no registration and no email address required. The files open in Microsoft Excel on Windows and Mac, in Google Sheets straight in your browser and in LibreOffice Calc, so you can edit the 2022/23 split year calendar online or offline, save a separate version for each team, department or project, and share it without anyone touching your own copy.How to use this split year calendar in Excel and Google Sheets
Each calendar is an .xlsx file that opens in Microsoft Excel, Google Sheets and LibreOffice Calc, so you can type dates straight into the day cells and shade whole runs of days to mark quarters, budget periods or closed weeks. Upload it to Google Drive and it becomes a split year calendar in Google Sheets that a whole team can work from, with everyone looking at the same copy instead of emailing versions around. Keep it on screen and update it as the year moves, save a separate copy for each project, and print it on US Letter paper whenever you want the current version on the wall. If what you need to add is sentences rather than shaded blocks of days, the Word and Google Docs edition gives each day more room to write in, and there is a ready-to-print PDF version for when the calendar only has to go on the wall.Who uses a July to June calendar
- State and local government, and nonprofits
July 1 to June 30 is the fiscal year for most US states, for a large share of counties, cities and school districts, and for many nonprofits. Budget cycles, grant periods, board meetings, audit dates and reporting deadlines all sit on one sheet instead of being cut in half by January. - Clubs, societies and sports leagues
Any season that runs across the winter fits a split year better than a calendar year: fixtures, training blocks, membership renewals, subscription years, committee terms and the annual general meeting. - Businesses on a mid-year financial year
Australian companies run July to June, and plenty of US businesses choose it too. Quarter ends, forecasting rounds, appraisal cycles, contract renewals and stocktakes all land where you can see them. - Anyone planning across New Year
A summer-to-summer view suits long projects, construction and renovation schedules, application and admissions cycles, secondments, sabbaticals and extended travel, where a January-to-December sheet would split the work across two calendars. - Home and family
Free to print for the fridge or a home office, with vacations, term dates, renewals and appointments visible across the whole span rather than stopping at December 31.
What to add to your 2022/23 split year calendar
The days are left blank because the dates that matter are your own. Once the sheet is in front of you, these are the entries that usually go on first:- The fixed points of the year
The start and end of your own year, quarter boundaries, and the closures and shutdown periods around them. - Money and reporting
Budget submission and approval dates, grant application and reporting deadlines, audit windows, invoicing and payroll runs, and year-end close. - People
Vacation and leave, appraisal and review cycles, contract and membership renewals, recruitment rounds and training dates. - Deadlines and milestones
Project phases, delivery dates, application and admissions deadlines, launches and go-live dates. - Everything else the year runs on
Board and committee meetings, the annual general meeting, fixtures and events, conferences and the days the office is closed.
Terms of Use
All templates on this site may be used free of charge, provided that the Calendarpedia logo, the copyright notice with the website address ("© Calendarpedia® www.calendarpedia.com") and the disclaimer ("Data provided 'as is' without warranty") are not removed. All content of this website is copyright © 2011-2026 Calendarpedia®. All rights reserved. Data provided 'as is' without warranty of any kind and subject to error and change without notice. Your use of this site indicates acceptance of our Terms of Use. More.Split year calendars 2022/23 for Microsoft Excel,
landscape orientation (4 templates)
Wide sheets, made for a wall: an office chart, a project board
or a planner a whole team can read from across the room.
or a planner a whole team can read from across the room.
Template 1 (Excel)
Editable split year calendar 2022/23
split year wall calendar, landscape, 1 page
The split year wall calendarThe complete July-to-June span on one landscape sheet, the second half of 2022 and the first half of 2023 side by side, with the change of calendar year falling in the middle of the page rather than at the edge. Pin it up and the whole of your year is visible at once. The months run across the top with the days below, and every box is left blank, because the dates that matter are yours.
- calendar for second half 2022 and first half 2023 on one page (running from July 1, 2022 to June 30, 2023)
- months arranged horizontally (along the top), days vertically
- 1 page, landscape orientation (horizontal)
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- holiday names printed beside the date, with Easter marked as well
- the change of calendar year falls in the middle of the sheet, not at the edge
- weekends shaded in the standard Calendarpedia design, so working days stand out
- suits an office wall, a project board or a shared noticeboard
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
Download template 1
Template 2 (Excel)
Editable split year calendar 2022/23
half-year split calendar, landscape, 2 pages
The half-year calendar with room to writeThe same July-to-June span split across two landscape sheets, six months to each: July to December on the first, January to June on the second. Halving the year doubles the size of every day box, which is what you want when the calendar is going to be written on rather than just read. Pinned up together they still give you the whole span on the wall, and the split falls neatly on the turn of the calendar year.
- calendar for second half 2022 and first half 2023 on 2 pages (running from July 1, 2022 to June 30, 2023)
- half a year (six months) per page
- 2 pages, landscape orientation (horizontal)
- July to December 2022 on page one, January to June 2023 on page two
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- larger day boxes than the one-page layout, with room to write deadlines in by hand
- the two sheets divide exactly at the turn of the calendar year
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
Download template 2
Template 3 (Excel)
Editable split year calendar 2022/23
linear split year timeline, landscape, 1 page
The linear split year timelineThe days run left to right in one continuous line with the month names down the left side, so the year reads as a timeline rather than a grid. That makes duration visible in a way a month grid never manages: the length of a project phase, the gap between a submission and a decision, the run of weeks to a deadline. A favorite for project and budget planning across the turn of the year.
- calendar for second half 2022 and first half 2023 on one page (running from July 1, 2022 to June 30, 2023)
- linear calendar (days arranged horizontally), month names down the left side
- names of the months arranged vertically down the left side
- use as split year project timeline tracker
- 1 page, landscape orientation (horizontal)
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- reads as a timeline, so the length of a phase, project or quarter is easy to measure
- works as a split year project timeline tracker
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
- a full-width color band above each half of the sheet, marking the 2022 months and the 2023 months
Download template 3
Template 4 (Excel)
Editable split year calendar 2022/23
year at a glance, landscape, 1 page
The year-at-a-glance split calendarTwelve month blocks across a single landscape page, July through June, in the familiar layout everyone can read without being shown how. This is a reference calendar rather than a planning one: you use it to check which week a date falls in, or how many weeks are left before a deadline, not to write the whole year into. A federal holidays table runs across the foot of the sheet, so every holiday of the span is named and dated in one place. Small enough to hand out or file inside the cover of a folder.
- calendar for second half 2022 and first half 2023 on one page (running from July 1, 2022 to June 30, 2023)
- classic design 12-months planner
- 1 page, landscape orientation (horizontal)
- all 12 months as separate month blocks on a single sheet
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- a federal holidays table at the foot of the sheet, listing every holiday of 2022/23 with its date
- a quick reference calendar for checking dates rather than writing entries in
- the portrait counterpart is template 7, the same twelve blocks on an upright sheet (portrait orientation)
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
Download template 4
Split year calendars 2022/23 for Microsoft Excel,
portrait orientation (4 templates)
Upright sheets, made to be carried: a binder, a folder, a desk
or the narrow strip of wall beside a door.
or the narrow strip of wall beside a door.
Template 5 (Excel)
Editable split year calendar 2022/23
two half-year blocks, portrait, 1 page
The portrait split year calendar in two blocksThe whole July-to-June span on one portrait page, arranged as two blocks of six months: July to December above, January to June below. Portrait fits where landscape will not, and splitting the year into two blocks keeps the months wide enough to read comfortably while still fitting the full span onto a single sheet. The two blocks divide at the turn of the calendar year.
- calendar for second half 2022 and first half 2023 on one page (running from July 1, 2022 to June 30, 2023)
- two half-year blocks on 1 page, portrait orientation (vertical)
- July to December in the upper block, January to June in the lower block
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- holiday names printed beside the date, with Easter marked as well
- the two blocks divide exactly at the turn of the calendar year
- portrait format fits a binder, a folder or a notebook
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
Download template 5
Template 6 (Excel)
Editable split year calendar 2022/23
compact split year calendar, portrait, 1 page
The compact split year calendarThe July-to-June span running top to bottom on one portrait page in a single narrow column, the most compact layout here. It fits a folder, a door or a corner of a noticeboard without taking over the space around it, which also makes it the cheapest one to photocopy for a whole team. Best where the year needs to be permanently visible rather than written on.
- calendar for second half 2022 and first half 2023 on one page (running from July 1, 2022 to June 30, 2023)
- 1 page, portrait orientation (vertical)
- days listed vertically in a continuous run from July to June
- the most compact of the layouts on this page
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- holiday names printed beside the date, with Easter marked as well
- cheap to photocopy for a whole team or committee
- the landscape counterpart is template 1, the same full span on a wide sheet for a wall
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
Download template 6
Template 7 (Excel)
Editable split year calendar 2022/23
year at a glance, portrait, 1 page
The portrait year-at-a-glance calendarThe traditional twelve-month grid in portrait, July through June. Familiar enough that anyone can read it without explanation, and compact enough to go out as a handout or to sit at the front of a folder. Like its landscape counterpart it carries a federal holidays table at the foot of the sheet, naming and dating every holiday of the span. Take this one when the calendar is for checking dates rather than recording them.
- calendar for second half 2022 and first half 2023 on one page (running from July 1, 2022 to June 30, 2023)
- 1 page, portrait orientation (vertical)
- all 12 months as separate month blocks on a single portrait sheet
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- a federal holidays table at the foot of the sheet, listing every holiday of 2022/23 with its date
- reads without explanation, so it works as a handout
- the landscape counterpart is template 4, the same reference calendar in a wide format
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
Download template 7
Template 8 (Excel)
Editable split year calendar 2022/23
rolling layout with weekdays in columns, portrait, 1 page
The rolling split year calendar with weekdays in columnsA continuous portrait layout in which each day of the week has its own column and the weeks run down the page. Anything on a weekly schedule lines up vertically: the Monday meeting, the Wednesday delivery, the Friday report. A named column down the right-hand side lists the federal holidays row by row and leaves room for your own notes beside them, which makes this the one layout that carries a written record as well as a grid.
- calendar for second half 2022 and first half 2023 on one page (running from July 1, 2022 to June 30, 2023)
- 1 page, portrait orientation (vertical)
- days of the week arranged in columns - good for planning repeating commitments
- weeks run continuously down the page from July to June
- all US federal holidays for 2022/23 marked in red on a pale pink background, on the date they are observed and on the actual date
- anything on a weekly schedule lines up in a single column
- suits standing meetings, deliveries, reporting runs and duty rotations
- the 2022 months headed in green and the 2023 months in blue, so the change of calendar year shows at a glance
- a "Federal holidays / notes" column down the right-hand side, with each holiday named on its own row and room to add your own notes
Download template 8
Software and file compatibility
Every template is saved in Microsoft Excel (.xlsx) format, fully supporting the open XML document standard.- Microsoft Office
Compatible with Excel 2007 through 2024, as well as Office 365 (Desktop, Mac, and Mobile). - 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 Microsoft 365 (formerly Office Online) or a free alternative such as FreeOffice PlanMaker or LibreOffice Calc, both of which open our templates without formatting errors (OpenOffice Calc unfortunately has formatting problems). - Legacy systems
For older versions (Excel 2000, XP, 2003), these files can be converted easily or used via Microsoft 365.