2023/24 school calendar:
8 free Excel templates

August 2023 to July 2024, one, two and four pages. For Excel and
Google Sheets. Free to download, edit and print, no sign-up.

Advertisement
Download 8 free school calendar templates for 2023-2024 in Microsoft Excel format (.xlsx), running from August 1, 2023 to July 31, 2024 and made for the US with the federal holidays marked. With both semesters on one sheet and the summer break at both ends, you can plan the whole school year without switching calendars in January. No registration or email sign-up needed.

Find the right school calendar for 2023/24

The whole school year on one page
Templates 1 and 6 give each month its own column with the days running down the page, and template 5 sets out the year in two half-year blocks. Template 3 is a linear calendar with one month per row, templates 4 and 7 are a classic year at a glance with the federal holidays listed below the twelve months, and template 8 is a rolling calendar with the weekdays in columns, so a weekly lab, club or quiz lines up all year.
More room to write
Need bigger day boxes for deadlines, field trips and test dates? Template 2 spreads the school year over two pages, August to January and February to July.
Federal holidays and weekends marked
Every template shows the US federal holidays of the 2023/24 school year, with the observed day off when a holiday falls on a weekend, and shades the Saturdays and Sundays so the school days stand out. The months of 2023 have red headings and those of 2024 blue ones. Everything else is left blank for the dates your district or homeschool sets, from the first day of school to the last.
Landscape or portrait
Templates 1 to 4 are in landscape for a classroom wall and templates 5 to 8 in portrait for a binder or a folder, all on US Letter paper (8.5 x 11 inches). To save color ink, you can print any template in black and white.
Edit in Excel, then print
Type your first day of school, breaks and grading periods straight into the day cells, shade a semester or an exam week, or add your own school 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, Excel for the web and LibreOffice Calc, so a whole department can work from one shared copy. Prefer to write by hand? The same calendars are available as PDF files.
When the school breaks usually fall in 2023/24, the federal holidays of the school year and ideas for filling in your calendar are listed below the templates.

School calendars 2023/24 for Microsoft Excel,
landscape orientation (4 templates)

Wide sheets, made for a wall: a classroom chart, a teachers' lounge planner
or a department bulletin board that a whole team can read from across the room.
Change to:  PDF (.pdf)   ·   Word (.docx)   
View large imageDownload Template 1: School year calendar 2023/24 in Microsoft Excel format, landscape, 1 page, August to July on one sheet
landscape, 1 page,
August to July on one sheet

Template 1 (Excel)
Editable school calendar 2023/24
school year wall calendar, landscape, 1 page

  • runs from August 1, 2023 to July 31, 2024
  • 1 page, landscape orientation (horizontal)
  • months arranged horizontally (along the top), days vertically
  • covers the full 2023-2024 school year on a single sheet, with the summer break at both ends
  • all US federal holidays for the 2023/24 school year already marked, so you only add what is local to your district
  • blank day boxes for your own first and last day of school, breaks, grading periods and in-service days
  • weekends shaded in the standard Calendarpedia design, so teaching days stand out
  • suits a classroom wall, a teachers' lounge or a department bulletin board
  • an editable school calendar for Excel and Google Sheets: type your term dates straight into the day cells
  • template 5 is the portrait counterpart, fitting the same full year onto an upright sheet (portrait orientation)

Download template 11 page · 27 KB · xlsx file
View large imageDownload Template 2: School year calendar 2023/24 in Microsoft Excel format, landscape, 2 pages, six months per sheet
landscape, 2 pages,
six months per sheet

Template 2 (Excel)
Editable school calendar 2023/24
half-year school calendar, landscape, 2 pages

  • runs from August 1, 2023 to July 31, 2024
  • 2 pages, landscape orientation (horizontal)
  • months arranged horizontally (along the top), days vertically
  • half a year (six months) per page
  • August to January on page one, February to July on page two
  • US federal holidays shown on both sheets, using the observed date whenever one falls on a weekend as well as the actual date
  • larger day boxes than the one-page layout, with room to write deadlines and exam dates in by hand
  • works as a wall chart with both sheets pinned up side by side
  • shade whole runs of days in Excel or Google Sheets to block out breaks and semesters

Download template 22 pages · 27 KB · xlsx file
View large imageDownload Template 3: School year calendar 2023/24 in Microsoft Excel format, landscape, 1 page, linear, days in a row
landscape, 1 page, linear,
days in a row

Template 3 (Excel)
Editable school calendar 2023/24
linear school year timeline, landscape, 1 page

  • runs from August 1, 2023 to July 31, 2024
  • 1 page, landscape orientation (horizontal)
  • linear calendar (days arranged horizontally)
  • names of the months arranged vertically down the left side
  • works as a school year project timeline tracker
  • US federal holidays marked along the strip, which makes the short teaching weeks easy to pick out
  • reads as a timeline, so the length of a unit, project or term is easy to measure
  • suits syllabus planning, long class projects, department schedules and homeschool blocks that do not follow a district calendar
  • edit in Microsoft Excel, Google Sheets or LibreOffice Calc, on a laptop, tablet or phone

Download template 31 page · 26 KB · xlsx file
View large imageDownload Template 4: School year calendar 2023/24 in Microsoft Excel format, landscape, 1 page, year at a glance
landscape, 1 page,
year at a glance

Template 4 (Excel)
Editable school calendar 2023/24
year at a glance, landscape, 1 page

  • runs from August 1, 2023 to July 31, 2024
  • 1 page, landscape orientation (horizontal)
  • classic month-block calendar design
  • all 12 months of the school year as separate month blocks on a single sheet
  • every US federal holiday of the school year shown on the date it is observed and the actual date
  • a quick reference calendar for checking dates rather than writing entries in
  • compact enough to hand out to a class or file inside the cover of a binder
  • works the same in Google Sheets as in Excel, so nobody needs a particular program installed
  • template 7 is the portrait counterpart, the same twelve month blocks on an upright sheet (portrait orientation)

Download template 41 page · 23 KB · xlsx file

School calendars 2023/24 for Microsoft Excel,
portrait orientation (4 templates)

Upright sheets for the places landscape will not fit: a binder, a course folder, a student planner,
a locker door or the narrow strip of wall beside a whiteboard.
Change to:  PDF (.pdf)   ·   Word (.docx)   
View large imageDownload Template 5: School year calendar 2023/24 in Microsoft Excel format, portrait, 1 page, two 6-month blocks
portrait, 1 page,
two half-year blocks

Template 5 (Excel)
Editable school calendar 2023/24
two half-year blocks, portrait, 1 page

  • runs from August 1, 2023 to July 31, 2024
  • two half-year blocks on 1 page, portrait orientation (vertical)
  • August to January in the upper block, February to July in the lower block
  • the whole school year on one sheet, without folding or turning a page
  • US federal holidays highlighted in both half-year blocks
  • portrait format fits a binder, a course folder or a notebook
  • weekends shaded so teaching days and breaks are easy to tell apart
  • keep the master in Google Sheets and let each teacher copy it for their own class
  • template 1 is the landscape counterpart, the same full year on a wide sheet for a wall

Download template 51 page · 26 KB · xlsx file
View large imageDownload Template 6: School year calendar 2023/24 in Microsoft Excel format, portrait, 1 page, compact vertical layout
portrait, 1 page,
compact vertical layout

Template 6 (Excel)
Editable school calendar 2023/24
compact school year calendar, portrait, 1 page

  • runs from August 1, 2023 to July 31, 2024
  • 1 page, portrait orientation (vertical)
  • twelve narrow month columns from August to July, with the days running down each column
  • the most compact of the school year layouts on this page
  • federal holidays still marked despite the compact size, so no day off gets lost
  • fits a locker door, a folder or a corner of a bulletin board
  • cheap to photocopy for a whole class, a grade level or a homeschool co-op
  • an editable school calendar in Google Sheets for anyone without Excel installed

Download template 61 page · 24 KB · xlsx file
View large imageDownload Template 7: School year calendar 2023/24 in Microsoft Excel format, portrait, 1 page, year at a glance
portrait, 1 page,
year at a glance

Template 7 (Excel)
Editable school calendar 2023/24
year at a glance, portrait, 1 page

  • runs from August 1, 2023 to July 31, 2024
  • 1 page, portrait orientation (vertical)
  • classic 12-month calendar design, August through July
  • all 12 months as separate month blocks on a single portrait sheet
  • all federal holidays of the 2023/24 school year marked, so students and parents can see the fixed days off at a glance
  • reads without explanation, so it works as a handout for students, parents and staff
  • a reference calendar for checking dates rather than recording them
  • editable in Excel and Google Sheets, printable from either when you want it on the wall
  • template 4 is the landscape counterpart, the same reference calendar in a wide format

Download template 71 page · 23 KB · xlsx file
View large imageDownload Template 8: School year calendar 2023/24 in Microsoft Excel format, portrait, 1 page, days in continuous (rolling) layout
portrait, 1 page,
weekdays in columns

Template 8 (Excel)
Editable school calendar 2023/24
rolling layout with weekdays in columns, portrait, 1 page

  • runs from August 1, 2023 to July 31, 2024
  • 1 page, portrait orientation (vertical)
  • days of the week arranged in columns - good for planning repeating events
  • weeks run continuously down the page from August to July
  • federal holidays marked in the weekday columns, showing at once which weeks lose a teaching day
  • anything on a weekly schedule lines up in a single column
  • suits recurring classes, labs, clubs, duty rotations, standing meetings and a four-day homeschool week
  • sort, shade and annotate the weekday columns in Excel or Google Sheets as the schedule changes

Download template 81 page · 23 KB · xlsx file

The 2023/24 school year: breaks and federal holidays

School breaks 2023/24: when they usually fall

There is no national school calendar in the US: every district sets its own dates, so the calendar of your school district is the one that counts. Most of them follow the same pattern, though, which helps when you are planning a family trip or a work schedule before the official dates are out:
First day of school
Most districts start between early August and the week after Labor Day, which is Monday, September 4, 2023. Schools in the South and Southwest tend to open in early to mid-August, while many in the Northeast wait until after Labor Day.
Thanksgiving break
Thanksgiving falls on Thursday, November 23, 2023. Most schools close from the Wednesday to the Friday, November 22 to November 24, and a growing number take the whole week of November 20 off.
Winter break
Usually about two weeks around Christmas Day (Monday, December 25) and New Year's Day (Monday, January 1, 2024), typically starting in the week of Monday, December 25, with classes back on or around Monday, January 8, 2024.
Long weekends and February break
Martin Luther King Jr. Day (Monday, January 15, 2024) and Presidents' Day (Monday, February 19, 2024) close most schools for a long weekend. Many districts in the Northeast make the week of Presidents' Day a full mid-winter break.
Spring break
One week, usually in March or April. Many districts put it next to Easter, which falls on March 31, 2024, taking the week before or the week after; others choose a fixed week in mid-March, often to line up with the local college.
Last day of school
Schools that start in early August usually finish in late May, often just before or after Memorial Day (Monday, May 27, 2024); those that start after Labor Day run into mid- or late June. Juneteenth (Wednesday, June 19) is a federal holiday and a day off in more and more districts that are still in session.

Federal holidays in the 2023/24 school year

All dates at a glance
Eleven federal holidays fall between August 1, 2023 and July 31, 2024, and all of them are marked in the Excel templates on this page:
  • Labor Day: Monday, September 4, 2023
  • Columbus Day: Monday, October 9, 2023
  • Veterans Day: Saturday, November 11, 2023 (observed on Friday, November 10)
  • Thanksgiving Day: Thursday, November 23, 2023
  • Christmas Day: Monday, December 25, 2023
  • New Year's Day: Monday, January 1, 2024
  • Martin Luther King Day: Monday, January 15, 2024
  • Presidents' Day: Monday, February 19, 2024
  • Memorial Day: Monday, May 27, 2024
  • Juneteenth: Wednesday, June 19, 2024
  • Independence Day: Thursday, July 4, 2024
Observed days and long weekends
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 (see observed holidays in our FAQ). In the 2023/24 school year one federal holiday falls on a weekend, and the templates mark its observed day off as well as the holiday itself. Labor Day, Columbus Day, Martin Luther King Jr. Day, Presidents' Day and Memorial Day always fall on a Monday, so each of them comes with a three-day weekend for anyone who has the day off. All the federal holidays are listed on our pages federal holidays 2023 and federal holidays 2024, and every template on this page marks them, so the long weekends are there before you add a single date.

What to add to your 2023/24 school calendar

The days are left blank because the dates that matter are local ones, whether they come from a district calendar or from a homeschool plan you set yourself. Once the sheet is in front of you, these are the entries that usually go on first:
The fixed points of the year
The first and last day of school, and the breaks around them: fall break, Thanksgiving break, winter break, spring break and the start of summer vacation.
The academic structure
Semester, trimester or quarter boundaries, marking and grading periods, report card dates and parent-teacher conferences.
The days that are not full days
Professional development and in-service days, early release days and half days, and the snow days worth leaving room for at the end of the year.
Assessment and deadlines
State testing windows, midterms and finals, project and assignment due dates, and the test prep weeks leading up to them.
Everything else the year runs on
Picture day, open house and back-to-school night, sports seasons, field trips, concerts, prom and graduation.

Who these 2023/24 school calendars are for

Teachers and the classroom
Map out all of 2023/24 before the year starts: unit plans, assessment dates, grading periods, field trips and in-service days. Print a landscape version as a wall chart for the classroom or the teachers' lounge, or take a portrait one for a lesson plan binder or a substitute folder, and hand the same sheet to everyone so the department is working from one calendar rather than four.
Students and assignments
A printable copy of the school year for a binder, a locker door or a study wall, with assignment deadlines, exam dates, study blocks and club meetings all in one place. The portrait layouts fit a notebook or a course pack, while the two-page version leaves enough room to write the actual due dates in rather than just marking them.
Homeschool families
A homeschool calendar you set yourself: your own start and end dates, co-op days, field trips and the weeks you are taking off, with teaching days easy to count against whatever your state requires. The linear and rolling layouts suit a four-day week or any schedule that does not follow the local district, and nothing on the sheet assumes a standard term structure.
School offices and administration
Enrollment dates, report card periods, parent-teacher conferences, board meetings and staff training all sit on a single sheet for 2023/24, which makes it straightforward to see what conflicts before anything is scheduled. Free to copy for every staff member, with nothing printed across the dates to get in the way of your own entries.
Parents and families
A free printable school calendar for the fridge or the kitchen bulletin board, where term dates, breaks, game schedules and pickup arrangements stay visible to everyone in the house. Useful for planning family trips around the school year rather than around the calendar year, and for seeing at a glance where a break lines up with a federal holiday.
Every kind of school
These calendars suit schools, colleges, universities and vocational institutions of every kind, public or private, as well as homeschools and co-ops, from preschool and kindergarten through elementary, middle and high school to graduate and professional programs, whatever the individual term, semester and vacation dates happen to be, because the dates you add are your own. See also: further information about the school year in the USA and the US education system in general.
School calendar or undated school year planner?
If you would rather not be tied to a particular year at all, there are undated school year planners. Nothing is dated on those, so one download covers this school year and every one after it, and you fill in the dates yourself.

Ideas for your 2023/24 school calendar in Excel

Color-coding grading periods and breaks
Give each semester, trimester or grading period a light fill color, breaks and holidays a stronger one, and testing windows, half days and field trips colors of their own. Format Painter copies a color from one block of days to the next, and a short key in an empty cell explains the colors to students and parents.
A copy for every class or grade level
Right-click the sheet tab, choose Move or Copy and check "Create a copy" to give each class, grade level or department its own copy of the school calendar in the same workbook. Keep a second worksheet listing tests, projects and events with the date, the class and the teacher, and Sort & Filter puts them in date order or shows one class 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?