2019/20 Split Year Calendar:
8 free Excel templates
July 2019 to June 2020, 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 2019 and the first half of 2020 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.
The two calendar years are color-coded throughout: the 2019 months carry a green heading and the 2020 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 2019-2020, 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 fit 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. One and two page versions come in both landscape and portrait; the four page quarterly version is landscape, and there are linear and rolling layouts besides the classic grid. Saturdays are shaded pale yellow, Sundays pale orange and federal holidays are 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 2019/20.
Free to download, editable, no sign-up
Every .xlsx file here is free to download and free to use, with no registration, no email address and no trial that runs out. Edit the 2019/20 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 a common fiscal year in the US: it is the budget year for most US states, for a large share of counties, cities and school districts, and for a great many nonprofits. On a July to June calendar, 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
Membership organizations, clubs and sports leagues whose season runs across the winter fit a split year better than a calendar year: games, training blocks, membership renewals, subscription years, committee terms and the annual meeting. - Businesses on a mid-year financial year
Plenty of US businesses run July to June rather than January to December, whether to match a customer's fiscal year, a seasonal trading cycle or an industry convention. Quarter ends, forecasting rounds, performance reviews, contract renewals and inventory counts 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, rotations and temporary assignments, 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, school calendar dates, renewals and appointments visible across the whole span rather than stopping at December 31.
What to add to your 2019/20 split year calendar
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, performance reviews, 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 meeting, the season schedule 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 2019/20 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 2019/20
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 2019 and the first half of 2020 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 your whole year is visible at once. The months run across the top with the days below, and every box is left blank.
- calendar for second half 2019 and first half 2020 on one page (running from July 1, 2019 to June 30, 2020)
- months arranged horizontally (along the top), days vertically
- day numbers 1 to 31 repeated down both the left and the right edge, so you can read across a wide sheet without losing the row
- 1 page, landscape orientation (horizontal)
- all US federal holidays for 2019/20 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
- weekends shaded in pale yellow for Saturdays and pale orange for Sundays, so working days stand out
- suits an office wall, a project board or a shared bulletin board
- the portrait counterpart is template 6, the same full span on an upright sheet
Download template 1
Template 2 (Excel)
Editable split year calendar 2019/20
half-year split calendar, landscape, 2 pages
The half-year calendar with room to spareThe 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 a single day has to hold more than a word or two. 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 2019 and first half 2020 on 2 pages (running from July 1, 2019 to June 30, 2020)
- half a year (six months) per page
- 2 pages, landscape orientation (horizontal)
- July to December 2019 on page one, January to June 2020 on page two
- all US federal holidays for 2019/20 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
- larger day boxes than the one-page layout, with room for deadlines and longer entries
Download template 2
Template 3 (Excel)
Editable split year calendar 2019/20
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 2019 and first half 2020 on one page (running from July 1, 2019 to June 30, 2020)
- linear calendar (days arranged horizontally), month names down the left side
- day numbers 1 to 31 along the top of the sheet and repeated along the bottom edge
- 1 page, landscape orientation (horizontal)
- all US federal holidays for 2019/20 marked in red on a pale pink background, on the date they are observed and on the actual date
- holidays shaded without a name, because a cell one day wide has no room for one
- 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
- a full-width color band above each half of the sheet, marking the 2019 months and the 2020 months
Download template 3
Template 4 (Excel)
Editable split year calendar 2019/20
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 2019 and first half 2020 on one page (running from July 1, 2019 to June 30, 2020)
- classic 12-month planner design
- 1 page, landscape orientation (horizontal)
- all 12 months as separate month blocks on a single sheet, four across and three down
- all US federal holidays for 2019/20 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 bottom of the sheet, listing every holiday of 2019/20 with its date
- a quick reference calendar for checking dates rather than writing entries in
- the portrait counterpart is template 7, which puts one calendar quarter on each row instead
Download template 4
Split year calendars 2019/20 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 2019/20
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 2019 and first half 2020 on one page (running from July 1, 2019 to June 30, 2020)
- 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 2019/20 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
- portrait format fits a binder, a folder or a notebook
Download template 5
Template 6 (Excel)
Editable split year calendar 2019/20
all twelve months, portrait, 1 page
The full split year on one portrait pageAll twelve months run across the sheet as columns under a colored band for each calendar year, with the day numbers 1 to 31 down both the left and the right edge. Reading across a row shows you what weekday the same date falls on in every month of the span, which is what you want when you are lining up a monthly reporting date or a recurring payment run. It is the densest layout here, so it fits a folder, a door or a corner of a bulletin board without taking over the space around it.
- calendar for second half 2019 and first half 2020 on one page (running from July 1, 2019 to June 30, 2020)
- 1 page, portrait orientation (vertical)
- all twelve months as columns across the sheet, days down the page
- day numbers 1 to 31 repeated down both edges, so you can read across a row from either side
- all US federal holidays for 2019/20 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 landscape counterpart is template 1, the same full span on a wide sheet for a wall
Download template 6
Template 7 (Excel)
Editable split year calendar 2019/20
year at a glance, portrait, 1 page
The portrait year-at-a-glance calendarThe traditional twelve-month grid in portrait, July through June, three blocks across and four down. That shape puts exactly one calendar quarter on every row, so the change of calendar year falls cleanly between the second and third rows rather than in the middle of one. 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 bottom 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 2019 and first half 2020 on one page (running from July 1, 2019 to June 30, 2020)
- 1 page, portrait orientation (vertical)
- all 12 months as separate month blocks on a single portrait sheet, three across and four down
- one calendar quarter per row, so the change of calendar year falls between two rows rather than inside one
- all US federal holidays for 2019/20 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 bottom of the sheet, listing every holiday of 2019/20 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
Download template 7
Template 8 (Excel)
Editable split year calendar 2019/20
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 2019 and first half 2020 on one page (running from July 1, 2019 to June 30, 2020)
- 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
- the part-weeks at each end are shown in full with the outside days grayed, so no week is cut in half
- all US federal holidays for 2019/20 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
- 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, the Office Open XML spreadsheet format standardized as ISO/IEC 29500.- Microsoft Excel
Compatible with Excel 2007 through 2024 on Windows and Mac, and with Microsoft 365. - 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 do not have Excel installed, Microsoft 365 for the web is free to use in a browser, and free desktop alternatives such as FreeOffice PlanMaker and LibreOffice Calc open our templates without formatting errors (OpenOffice Calc unfortunately has formatting problems). - Editing on a phone or tablet
The Excel app for Android and iOS and the Google Sheets app both open these files, so you can add or check a date away from your desk and print the sheet later from any computer.