November 2026 This month's calendar →
Free · .xlsx · No macros

Monthly Calendar Template for Excel

A free Excel monthly calendar you never have to redraw. Type a year and a month number, and the template fills in the dates, the month name and India's holidays. Each date has a box underneath for your own notes, and it prints on a single A4 page.

What's inside

How the template works

1

Two yellow cells

Year goes in C2 and the month number in C3. They are the only cells you need to change; everything else is calculated.

2

Dates by formula

Each box works out its own date from the first Sunday of the grid, so leap years and 31-day months are always right.

3

Holidays filled in

India's holidays and festivals for 2026 and 2027 sit on a second sheet and appear under the matching dates. Add your own rows to it.

Tips

Getting more out of it

Make twelve months at once

Right-click the Calendar tab, choose Move or Copy and tick “Create a copy”. Set a different month in each copy to build the whole year in one file.

Print on one page

The print area and “fit to one page” are already set for A4 landscape. Use File → Print and check the preview shows a single page.

Shared family or office calendar

Save the file to OneDrive and share it, so everyone can type plans into the boxes under each date.

Prefer Google Sheets?

The same file opens in Google Sheets with every formula working. See the Google Sheets monthly calendar steps.

FAQ

Excel template questions

Is the Excel monthly calendar template free?

Yes. Download it, edit it and print it as often as you like.

Which Excel versions does it work in?

Any version from Excel 2010 onwards, Excel for the web, and LibreOffice Calc. It uses only standard date functions — no macros.

How do I change the month?

Type the month number (1 to 12) in cell C3 and the year in C2. The whole grid, the title and the holidays update at once.

Can I add my own holidays or birthdays?

Yes. Add a row on the Holidays sheet with the date in column A and the name in column B; it appears on the calendar automatically.

Does the week start on Sunday or Monday?

The template starts on Sunday, the usual layout for Indian calendars. For a Monday start, use the printable calendar tool on this site.

More

Other formats

Just need paper? Use the printable monthly calendar or download a monthly calendar PDF.