2016/17 Split Year Calendar:
2 free Excel templates
July 2016 to June 2017, 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 2016 and the first half of 2017 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 2016 months carry a green heading and the 2017 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 2016-2017, 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 2016/17.
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 2016/17 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 2016/17 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 2016/17 for Microsoft Excel,
landscape orientation (1 template)
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.
landscape, 1 page,
July to June on one sheet
Template 1 (Excel)
Editable split year calendar 2016/17
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 2016 and the first half of 2017 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 2016 and first half 2017 on one page (running from July 1, 2016 to June 30, 2017)
- months arranged horizontally (along the top), days vertically
- 1 page, landscape orientation (horizontal)
- all US federal holidays for 2016/17 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 2016 months headed in green and the 2017 months in blue, so the change of calendar year shows at a glance
Download template 1
Split year calendars 2016/17 for Microsoft Excel,
portrait orientation (1 template)
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.
portrait, 1 page,
year at a glance
Template 2 (Excel)
Editable split year calendar 2016/17
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 2016 and first half 2017 on one page (running from July 1, 2016 to June 30, 2017)
- 1 page, portrait orientation (vertical)
- all 12 months as separate month blocks on a single portrait sheet
- all US federal holidays for 2016/17 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 2016/17 with its date
- reads without explanation, so it works as a handout
- the 2016 months headed in green and the 2017 months in blue, so the change of calendar year shows at a glance
Download template 2
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.