Yearly Calendar with Public Holidays
Display a full-year calendar with public holidays automatically highlighted and formatted by month.
This template generates a comprehensive yearly calendar view with each month displayed in a grid layout. Public holidays are automatically marked and indexed, making it easy to see at a glance when important dates fall. Perfect for organizations, schools, and businesses that need to plan around statutory holidays and manage scheduling across the entire year.
What's inside
- Automatic month-by-month grid layout
- Public holiday indexing and highlighting
- Dynamic date calculations using DATE formulas
- Weekday-based positioning
- Multi-month visibility on single view
Download this template
.xlsx · 1 sheet · included with lifetime access
More in Calendars & Scheduling
Calendars & Scheduling14-Month School Year Calendar
Plan the full school year across 14 months with automatic date calculations and day-of-week formatting.
- Automatic date calculation based on selected year
- Day-of-week display for each date
- 14-month layout for full academic year coverage
Calendars & Scheduling14-Month School Year Calendar Template
Track the complete school year with a 14-month calendar view including holidays and key dates.
- 14-month calendar layout
- Automatic date and weekday calculation
- School name and year fields
Calendars & Scheduling2 Page Monthly Planner
Plan your month with a two-page layout showing dates, days, and key events at a glance.
- Auto-calculated dates using DATE formula
- Day-of-week organization via WEEKDAY function
- Year and month customization fields
Calendars & Scheduling2003 Calendar
Monthly calendar template for 2003 with day-by-day grid layout for planning and scheduling.
- Monthly grid layout
- Day-of-week columns
- Full year 2003 coverage