Perpetual Calendar (Free Excel)
A free perpetual calendar for Excel. Enter any year and the full 12 month calendar rebuilds itself, so you never need to make a new one.
Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 3 sheets.
What is inside the perpetual calendar
| Sheet | What it does |
|---|---|
| Calendar | Type a year and choose Sunday or Monday as the first day of the week. All 12 months update. |
| Events | List dates for birthdays, holidays and deadlines. They are highlighted on the calendar. |
| Read me | Short instructions. |
Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.
How to use it
- Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
- Replace the sample data in the yellow cells with your own.
- Read the totals and results that update automatically.
- Save a copy for each month, project or client, or print it from File > Print.
The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
What is a perpetual calendar?
A calendar that works for any year. This one recalculates all dates from the year you type, including leap years.
How do I make a perpetual calendar in Excel?
Use the DATE and WEEKDAY functions to find the first day of each month, then fill the grid with days. This template already has the formulas.
Does it handle leap years?
Yes. February shows 29 days in leap years such as 2028, tested against a standard calendar library.
Can I print it?
Yes. It is set to fit one landscape page.
Need a custom spreadsheet built for your business?
Talk to usMore free tools: All free Excel templates · 2027 calendar · Weekly calendar template · Timeline template