A routine calendar is more useful when it does more than show whether you completed a habit.
In this guide, you will build a monthly routine calendar in Excel that tracks daily habits, counts completed days, calculates completion percentages, displays visual progress bars, and gives you a simple monthly summary.
Create a row for each routine, columns for days 1 through 31, and a completion column that counts your finished days. Then divide that count by the number of days in the month and use conditional formatting to display the result as a progress bar.
What the Routine Calendar Tracks
The goal is to keep the daily part simple while letting Excel handle the calculations.
Set the Month and Your Routines
Start by choosing the month you want to track and listing the routines you care about.
For example:
Workout
Read 20 minutes
No-spend day
Drink water
Deep work
Stretch
Sleep before 11
Start with five to eight routines instead of tracking everything at once. A shorter list is easier to maintain consistently.
Create the Daily Tracking Grid
Put the routine names in the first column, then create day columns from 1 through 31.
Your basic layout can look like this:
Mark Each Completed Day
For the simplest version, type x whenever you complete a routine.
This method works across a wide range of Excel versions and keeps the template easy to edit.
If your version of Excel includes the newer in-cell checkbox feature, you can use checkboxes instead. For a broadly compatible downloadable template, this version uses a simple x marker.
Count the Number of Completed Days
COUNTIF can count how many daily cells contain your completion marker.
=COUNTIF(E6:AI6,"x")
Microsoft defines COUNTIF as a function that counts cells in a range when they match a specified condition. :chatgpt-content-reference{index="1"}
Calculate the Monthly Completion Rate
Next, divide the number of completed days by the number of days in the selected month.
=B6/DAY(EOMONTH($B$1,0))
Format the result as a percentage and copy the formula down for each routine.
Show Your Progress Automatically
A percentage is useful, but a visual progress bar makes the tracker much easier to scan.
2. Open Home > Conditional Formatting.
3. Choose Data Bars.
4. Pick a style.
5. The bar grows as your completion percentage increases.
Microsoft explains that Data Bars visualize a cell value relative to other values, with a longer bar representing a larger value. :chatgpt-content-reference{index="2"}
Highlight Completed Days
You can also use conditional formatting on the daily grid so cells containing x become green.
Instead of reading every x, you can scan the calendar and immediately see which routines have the most consistent green blocks.
Add a Monthly Summary
Once the daily tracker is working, add a small summary below the calendar.
Useful summary metrics include:
Review Your Month
The purpose of the summary is not to make every habit reach 100%.
It helps you see patterns. You may discover that one routine is easy to maintain while another consistently drops off after a few days.
Which habit was hardest to maintain?
Did weekends affect consistency?
Are you tracking too many habits?
Which routines should stay next month?
Reuse the Calendar Next Month
You do not need to rebuild the sheet each month.
Duplicate the workbook or clear the daily tracking cells, change the month start date, and adjust your routine list if needed.
If the formulas are linked to the month start date, the number of days and calendar labels can update automatically.
Download the Ready-Made Excel Template
The downloadable workbook already includes a Setup sheet, 31-day routine grid, completion formulas, progress bars, monthly summary, and habit-completion chart.
Ideas for Other Routine Calendars
Frequently Asked Questions
A routine calendar does not need complicated formulas to be useful. Track each completed day, count the results with COUNTIF, calculate a monthly percentage, and use visual progress bars to make your consistency easy to understand.
This guide is based on current Microsoft Excel documentation for COUNTIF and conditional-formatting Data Bars. Last checked: October 2026.