2018/19 split year calendar:
5 free Excel templates
July 2018 to June 2019, one page. For Excel and
Google Sheets. Free to download, edit and print, no sign-up.
Advertisement
Find the right split year calendar for 2018/19
The whole split year on one page
Choose month columns with every date on its own row (templates 1 and 4), a linear timeline with the days running across the page (template 2), or a classic year at a glance with a federal holidays table (templates 3 and 5, the portrait one with one calendar quarter per row).
Choose month columns with every date on its own row (templates 1 and 4), a linear timeline with the days running across the page (template 2), or a classic year at a glance with a federal holidays table (templates 3 and 5, the portrait one with one calendar quarter per row).
Two calendar years, two colors
The 2018 months carry a light green heading and the 2019 months a light blue one, so you can see at once which side of New Year a date falls on. Saturdays are shaded pale yellow and Sundays pale orange. To save color ink, you can print any template in black and white.
The 2018 months carry a light green heading and the 2019 months a light blue one, so you can see at once which side of New Year a date falls on. Saturdays are shaded pale yellow and Sundays pale orange. To save color ink, you can print any template in black and white.
Landscape or portrait
Templates 1 to 3 are in landscape and templates 4 to 5 in portrait, all sized for US Letter paper (8.5 x 11 inches).
Templates 1 to 3 are in landscape and templates 4 to 5 in portrait, all sized for US Letter paper (8.5 x 11 inches).
US federal holidays already marked
Every federal holiday from July 2018 to June 2019 is printed in red on pale pink, and when one falls on a weekend, the observed day off is marked too (see observed holidays in our FAQ). Most templates print the holiday name beside the date; the linear timeline shades holidays without a name.
Every federal holiday from July 2018 to June 2019 is printed in red on pale pink, and when one falls on a weekend, the observed day off is marked too (see observed holidays in our FAQ). Most templates print the holiday name beside the date; the linear timeline shades holidays without a name.
Edit in Excel, then print
Type dates straight into the day cells, shade whole runs of days to mark budget periods or closed weeks, or add your own logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colors or logo). The Excel calendar also opens in Google Sheets and LibreOffice Calc. Prefer to write by hand? The same calendars are available as PDF files.
Type dates straight into the day cells, shade whole runs of days to mark budget periods or closed weeks, or add your own logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colors or logo). The Excel calendar also opens in Google Sheets and LibreOffice Calc. Prefer to write by hand? The same calendars are available as PDF files.
Split year calendars 2018/19 for Microsoft Excel,
landscape orientation (3 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 2018/19
split year wall calendar, landscape, 1 page
- calendar for second half 2018 and first half 2019 on one page (running from July 1, 2018 to June 30, 2019)
- months arranged horizontally (along the top), days vertically
- 1 page, landscape orientation (horizontal)
- US federal holidays in red , on observed and actual dates
- 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 4, the same full span on an upright sheet
Download template 11 page · 26 KB · xlsx file
Template 2 (Excel)
Editable split year calendar 2018/19
linear split year timeline, landscape, 1 page
- calendar for second half 2018 and first half 2019 on one page (running from July 1, 2018 to June 30, 2019)
- 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)
- US federal holidays in red , on observed and actual dates
- 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 2018 months and the 2019 months
Download template 21 page · 26 KB · xlsx file
Template 3 (Excel)
Editable split year calendar 2018/19
year at a glance, landscape, 1 page
- calendar for second half 2018 and first half 2019 on one page (running from July 1, 2018 to June 30, 2019)
- 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
- US federal holidays in red , on observed and actual dates
- a federal holidays table at the bottom of the sheet, listing every holiday of 2018/19 with its date
- a quick reference calendar for checking dates rather than writing entries in
- the portrait counterpart is template 5, which puts one calendar quarter on each row instead
Download template 31 page · 23 KB · xlsx file
Split year calendars 2018/19 for Microsoft Excel,
portrait orientation (2 templates)
Upright sheets for the places landscape will not fit: 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 4 (Excel)
Editable split year calendar 2018/19
all twelve months, portrait, 1 page
- calendar for second half 2018 and first half 2019 on one page (running from July 1, 2018 to June 30, 2019)
- 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
- good for lining up monthly reporting dates and recurring payment runs
- US federal holidays in red , on observed and actual dates
- 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 41 page · 24 KB · xlsx file
Template 5 (Excel)
Editable split year calendar 2018/19
year at a glance, portrait, 1 page
- calendar for second half 2018 and first half 2019 on one page (running from July 1, 2018 to June 30, 2019)
- 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
- US federal holidays in red , on observed and actual dates
- a federal holidays table at the bottom of the sheet, listing every holiday of 2018/19 with its date
- reads without explanation, so it works as a handout
- the landscape counterpart is template 3, the same reference calendar in a wide format
Download template 51 page · 23 KB · xlsx file
Split year 2018/19: federal holidays and key dates
Federal holidays from July 2018 to June 2019
All dates at a glance
There are ten federal holidays in the split year 2018/19, and all of them are marked in the Excel templates on this page:
There are ten federal holidays in the split year 2018/19, and all of them are marked in the Excel templates on this page:
- Wednesday, July 4, 2018: Independence Day
- Monday, September 3, 2018: Labor Day
- Monday, October 8, 2018: Columbus Day
- Sunday, November 11, 2018: Veterans Day (observed Monday, November 12)
- Thursday, November 22, 2018: Thanksgiving Day
- Tuesday, December 25, 2018: Christmas Day
- Tuesday, January 1, 2019: New Year's Day
- Monday, January 21, 2019: Martin Luther King Day
- Monday, February 18, 2019: Presidents' Day
- Monday, May 27, 2019: Memorial Day
The two halves in numbers
July 1 to December 31, 2018 has 184 days, 131 weekdays and 125 working days; January 1 to June 30, 2019 has 181 days, 129 weekdays and 125 working days. That gives the whole split year 365 days and 250 working days (Monday to Friday, not counting the federal holidays and their observed days).
July 1 to December 31, 2018 has 184 days, 131 weekdays and 125 working days; January 1 to June 30, 2019 has 181 days, 129 weekdays and 125 working days. That gives the whole split year 365 days and 250 working days (Monday to Friday, not counting the federal holidays and their observed days).
Daylight Saving Time
Daylight Saving Time ends on Sunday, November 4, 2018, when the clocks go back one hour, and begins again on Sunday, March 10, 2019, when they go forward one hour. Hawaii and most of Arizona stay on standard time all year.
Daylight Saving Time ends on Sunday, November 4, 2018, when the clocks go back one hour, and begins again on Sunday, March 10, 2019, when they go forward one hour. Hawaii and most of Arizona stay on standard time all year.
Who uses a July to June calendar
Why a split year calendar
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 2018 and the first half of 2019 on one sheet. If the twelve months you care about straddle New Year, a January to December calendar splits them across two sheets - a split year calendar does not.
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 2018 and the first half of 2019 on one sheet. If the twelve months you care about straddle New Year, a January to December calendar splits them across two sheets - a split year calendar does not.
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 and reporting deadlines all sit on one sheet instead of being cut in half by January.
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 and reporting deadlines all sit on one sheet instead of being cut in half by January.
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. The Australian financial year runs from July 1 to June 30 as well, so the same layouts suit a July to June financial year there - bear in mind that the holidays marked are the US federal holidays.
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. The Australian financial year runs from July 1 to June 30 as well, so the same layouts suit a July to June financial year there - bear in mind that the holidays marked are the US federal holidays.
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.
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.
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.
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.
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 2018/19 split year calendar
Once the sheet is in front of you, these are the entries that usually go on first: the start and end of your own year, quarter boundaries and the closures around them; budget submission and approval dates, grant application and reporting deadlines and the year-end close; vacation and leave, performance reviews, contract and membership renewals, recruitment rounds and training dates; project phases, delivery dates, application and admissions deadlines, launches and go-live dates; and board and committee meetings, the annual meeting, the season schedule, conferences and the days the office is closed.
Once the sheet is in front of you, these are the entries that usually go on first: the start and end of your own year, quarter boundaries and the closures around them; budget submission and approval dates, grant application and reporting deadlines and the year-end close; vacation and leave, performance reviews, contract and membership renewals, recruitment rounds and training dates; project phases, delivery dates, application and admissions deadlines, launches and go-live dates; and board and committee meetings, the annual meeting, the season schedule, conferences and the days the office is closed.
Ideas for your 2018/19 split year calendar in Excel
Color-coding teams, programs and events
Give each team, program or activity its own fill color and shade its games and meetings across the year, and conflicts between them show right away. Format Painter copies a color from one day to the next, and a short key in an empty cell explains the colors to the board.
Give each team, program or activity its own fill color and shade its games and meetings across the year, and conflicts between them show right away. Format Painter copies a color from one day to the next, and a short key in an empty cell explains the colors to the board.
A copy for every team and a list of events
Right-click the sheet tab, choose Move or Copy and check "Create a copy" to give each team or program its own July to June calendar in the same workbook. Keep a second worksheet listing games and events with the date, the team and the location, and Sort & Filter puts them in date order or shows one team at a time.
Right-click the sheet tab, choose Move or Copy and check "Create a copy" to give each team or program its own July to June calendar in the same workbook. Keep a second worksheet listing games and events with the date, the team and the location, and Sort & Filter puts them in date order or shows one team at a time.
Using the templates
Terms of Use
All templates on this site may be used free of charge, at home, at work and at school, 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") stay on the template. The templates may not be sold or built into products that are sold, and the blank templates (or copies with only minor changes) may not be offered for download on other websites. All content on this site is protected by copyright © 2011-2026 Calendarpedia®. All rights reserved. Data is provided 'as is' without warranty of any kind, may contain errors and is subject to change without notice. If you find a mistake, please let us know. Full details are in our Terms of Use.
System requirements and compatibility
Every template is saved in Microsoft Excel (.xlsx) format, the Office Open XML spreadsheet format standardized as ISO/IEC 29500.
- Microsoft Excel
The templates open in Excel 2007 and later for Windows, Excel 2008 and later for Mac, Microsoft 365 and Excel for the web. - 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. Apple's Numbers opens the files too, but the layout may shift, and OpenOffice Calc unfortunately has formatting problems with some of our calendars. - 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 an entry away from your desk and print the sheet later from any computer. - Your own dates, colors and logo
Type your entries straight into the day cells, shade the days that matter to you and add your own logo alongside the Calendarpedia logo - our FAQ shows how to add your own dates, colors or logo. - Printing in black and white
To save color ink, you can print any template in black and white. - Older versions of Excel
Excel 2003 and older versions can't open .xlsx files directly. Open the template in Excel for the web or one of the free programs above instead, or use the PDF version of the calendar.
How to open and print these templates in Google Sheets
Download the .xlsx file first. Then either drag it into Google Drive, right-click it and choose Open with → Google Sheets, or open Sheets and go to File → Open → Upload. The template keeps its layout and colors, and you can type into the cells and change the fill colors exactly as you would in Excel.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
Problems downloading, opening or printing a template?
Our FAQ explains how to print a template in a different size or in black and white, what to do if the edges are cut off, a download doesn't work or a file won't open in Excel or Word, which other programs you can use and how to add your own dates, colors or logo.




