Pick a year and download a printable calendar as .xlsx: one landscape page per month, or the whole year on one page. Every date is a formula on the year cell, so typing a new year into the file redraws it.
100% private. The calendar is built in your browser. Nothing is sent to our servers.
This Excel calendar template generator builds a printable .xlsx calendar for the year you pick, either one sheet per month or the whole year on one page, in your browser. Every date in it is a formula on one Year cell, so the same file becomes next year's calendar when you type a new number. That matters to anyone who has downloaded a template, typed 2027 over 2026 in the title, and watched every date stay where it was.
It's free, with no usage limit and no sign-up.
| Part | One sheet per month | Whole year on one page |
|---|---|---|
| Sheets | 12, named January to December | 1, named Year |
| Heading | Month and year, a formula shown like "January 2027" | The year |
| Grid | Weekday names, then six weeks; each week is a row of dates over a tall row to write in | 12 small months, three across and four down, with one-letter weekday headings |
| Year cell | Yellow cell I2 on the January sheet | Yellow cell Y2 beside the calendar |
| Weekends | Saturday and Sunday columns shaded grey | Same |
| Today | Dark green with white text | Same |
| Days outside the month | Empty boxes, greyed | Empty |
| Notes (optional) | Four lines under each month | Four lines under the year |
| Printing | Each month on one landscape page | The whole year on one landscape page |
Today's highlight is conditional formatting built on TODAY(), so it moves each day you open the file. Six week rows are enough for every month. January 2027 starts on a Friday and needs all six in a Sunday-first calendar, while February 2027 starts on a Monday and fits in four with Monday first. Gridlines are off, each sheet's print area is set, and the file's author and company properties read xlsx.com.
Type the new year into the yellow Year cell: I2 on the January sheet, or Y2 on the one-page layout. That cell is named CalendarYear and every date in the file points at it, so typing 2028 over 2027 redraws all 12 months. Tested in Excel for Mac: changing 2026 to 2028 turned the February heading into February 2028, with a 29th. The grey on out-of-month boxes in the monthly layout is conditional formatting too, so it follows the dates.
A calendar built the other way can't do this. When the year is typed as text in a heading and the day numbers are plain values, overwriting the year changes the heading and nothing else: the 1 of January stays under Friday, where 2027 put it, though 1 January 2028 is a Saturday. Generators that write the dates into the file as fixed values have the same problem. Before you count on a downloaded template for next year, check that its description says you can set the year.
Each day cell holds the same pattern. Here is the first box of January in a Sunday-first calendar:
=IF(MONTH(DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),1)+1)=1,
DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),1)+1, "")
// DATE(CalendarYear,1,1) 1 January of the year in the Year cell
// WEEKDAY(...,1) 1 for Sunday up to 7 for Saturday
// -WEEKDAY(...)+1 steps back to the Sunday that starts the first row
// IF(MONTH(...)=1, ...) shows the date only if it falls in JanuaryFor 2027, 1 January is a Friday, so this box works out to 27 December 2026 and stays empty; the sixth box lands on the 1st. Each box after the first adds one more day. A Monday-first file uses 2 as WEEKDAY's second argument, which counts from Monday.
Leap years come free with DATE. February gets 29 days in 2028 and 2000 and 28 in 2027 and 2100, because the 29th of February 2027 is really 1 March, which the MONTH test rejects. More on the week arithmetic in the WEEKDAY article.
The dates are formulas; the boxes under them are ordinary cells. Type "Dentist 3pm" under 12 May 2027, change the year to 2028, and the note sits under 17 May 2028. Before you reuse a filled-in calendar for a new year, save a copy for each year (File > Save As), or download a fresh calendar and keep the old one as a record.
The file has no public holidays, since they differ by country. For a few, type the name into the day's box or give it a fill colour. For a list that colours itself, in the monthly layout:
=DATE(CalendarYear,12,25), keeps fixed-date holidays in step with the Year cell. For the ones that float, like Thanksgiving, see the US holiday list article.=AND(ISNUMBER(A3),COUNTIF(Holidays,A3)>0)
// A3 the first date cell on every month sheet
// ISNUMBER skips the empty out-of-month boxes and the writing rows
// COUNTIF is this date in the Holidays list?Click Format, pick a colour on the Fill tab, and click OK twice. Conditional formatting belongs to one sheet, so repeat the rule on each month you want it on. COUNTIF has the details.
A template. In Excel 365, File > New and a search for "calendar" brings up Microsoft's templates. Read the description before you pick one: if it doesn't say you can set the year and the first day of the week, assume the dates are fixed to the year it was drawn for.
One formula. In Excel 365 or 2021, put the first of the month in a cell named start, for example =DATE(2027,1,1), then enter this in the top-left cell of an empty 6-by-7 block:
=SEQUENCE(6,7,start-WEEKDAY(start,2)+1)
// 6,7 six weeks of seven days
// start-WEEKDAY(start,2)+1 the Monday on or before the 1stFormat the block with the custom number format d, add a weekday row above it, and grey the neighbouring months with the rule =MONTH(A3)<>MONTH(start), where A3 is the block's first cell. It's a good route for one month on a dashboard. For a year of printable pages, it's 12 blocks, 12 rules and the print setup to repeat on each sheet. The SEQUENCE function article covers the spill behaviour.
Planning a project across those months? The Gantt chart generator draws task bars with conditional formatting that read each task's start and end dates, so editing a date in Excel moves its bar. For money over the same 12 months, the budget template generator builds a planned-against-actual sheet with a column for each month.
Yes. In Excel 365, go to File > New and search for calendar to see Microsoft's templates. Read a template's description before you rely on it for next year: unless it says you can set the year, retyping the year may change only the heading.
It depends on how the template was built. If the day numbers are typed values, changing the year title moves nothing, and you need a different template. In the file from this page, type the new year into the yellow Year cell (I2 on the January sheet, or Y2 on the one-page layout) and every month redraws.
Calculate every date from one year cell instead of typing the days. Each month starts from DATE(year, month, 1), and WEEKDAY works out how many boxes to step back to the start of the week. The file this page builds works that way, with the year cell named CalendarYear.
Pick Monday before you download; the weekday names and the grey weekend columns follow that choice. In a formula-built calendar, the switch is WEEKDAY's second argument: 1 counts from Sunday, 2 from Monday. The week start is fixed once this page's file is made, so switching later means downloading again.
Type the holiday into that day's box, or give it a fill colour. For holidays that recolour themselves, list their dates on a spare sheet, name the list Holidays, and add a conditional formatting rule that uses COUNTIF to check each date against it. This page's file has no holidays built in, because they differ by country.
Choose the whole year layout: it puts 12 small months on one sheet that prints on one landscape page. With the one sheet per month layout, each month prints on its own landscape page, and File > Print > Print Entire Workbook sends all 12 in one go.
No. Text typed into a day's box stays in that cell, and after a year change the cell belongs to a different date. Save a copy of the file for each year before you retype the year, or download a fresh calendar for the new year.