How to make a yearly calendar in Excel
- Keep “Year calendar with events” selected and type the year.
- Add a title or your name if you like.
- Click Create and open the .xlsx in Excel, Google Sheets or LibreOffice.
A printable calendar for the fridge or the office wall, a planning sheet for a project, a school year overview: this template gives you a full year on one sheet, built with DATE and WEEKDAY formulas rather than typed numbers. Change the year in the yellow cell and all twelve months move to the right days; weekends are shaded.
A second sheet, Events, lets you list dates with an event, a category (work, personal, birthday, holiday) and notes, so the file doubles as a simple planner. The calendar sheet is set up to print landscape on one page.
The workbook is a standard .xlsx that opens in Excel, Google Sheets, LibreOffice Calc and Numbers. No macros, no links to the outside, no account needed. Pick the English version for a Sunday-first week or the French one for Monday-first, add a title such as your company name, and reuse the same file every year by changing one cell.
Frequently asked questions
Does it work for any year?
Yes. Type the year in cell B5 and the twelve months recalculate, including leap years.
Does the week start on Sunday or Monday?
On Sunday in the English version, on Monday in the French one.
Can I add my events?
Yes, on the Events sheet: date, event, category and notes.
Will it print on one page?
Yes, the calendar sheet is set to print landscape on a single page.
Is it free?
Yes, free and without an account.