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
Download 5 free split year calendar templates for 2018-2019 in Microsoft Excel format (.xlsx), running from July 1, 2018 to June 30, 2019 with all US federal holidays marked. The second half of 2018 and the first half of 2019 sit together on one calendar, so a state or nonprofit budget year, a sports season or a long project is never cut in half at New Year. No registration or email sign-up needed.

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).
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.
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).
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.
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.
The federal holidays of 2018/19, the working days in each half of the split year and who uses a July to June calendar are listed below the templates.

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.
Change to:  PDF (.pdf)   ·   Word (.docx)   
Download Template 1: Microsoft Excel template for split year calendar 2018/19 (landscape orientation, 1 page)
landscape, 1 page,
July to June on one sheet

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
Download Template 2: Microsoft Excel template for split year calendar 2018/19 (landscape orientation, days linear, 1 page)
landscape, 1 page, linear,
days in a row

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
Download Template 3: Microsoft Excel template for split year calendar 2018/19 (landscape orientation, 1 page, year at a glance)
landscape, 1 page,
year at a glance

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.
Change to:  PDF (.pdf)   ·   Word (.docx)   
Download Template 4: Microsoft Excel template for split year calendar 2018/19 (portrait, 1 page)
portrait, 1 page,
all twelve months as columns

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
Download Template 5: Microsoft Excel template for split year calendar 2018/19 (portrait, 1 page, year at a glance)
portrait, 1 page,
year at a glance

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: A federal holiday that falls on a Saturday is observed on the Friday before, and one that falls on a Sunday on the Monday after; the templates mark both days. Our pages federal holidays 2018 and federal holidays 2019 have more about each of them.
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).
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.

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.
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.
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.
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.
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 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.

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.
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.

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.

Problems downloading, opening or printing a template?