Use my Excel events calendar to track meetings and events inside a workbook. Add your upcoming events to a list, set a start date, and then see those items in a 6-week calendar view.
Video: Daily Events Calendar in Excel
In this short video, I show how to use the daily events Excel calendar, and I give a quick look at how the calendar formulas works.
- Tip: To follow along, you can get the Excel file from the Excel Calendars page on my Contextures site.
Go to a Section:
- Step 1: Prepare the Events Sheet
- Step 2: Use the Settings Sheet
- Step 3: See the Calendar View
- Step 4: Add and Manage Events
- FAQ
Step 1: Prepare the Events Sheet
In the Excel calendar workbook is named Events. It has a named Excel table, and that’s where you list each event in its own row. You’ll enter 3 bits of information for each event:
- Date (the day of the event)
- Time (start time)
- Short detail (what the event is)
For example, enter “5/14/2025” in the Date column, “5:00 PM” in the Time column, and “Dinner” in the Detail column.
The event list also has helper column, with a formula that combines the time and detail into one cell. The calendar view uses that combined data.
Step 2: Use the Settings Sheet
The Excel file also has a sheet named Settings. That sheet has input cells, and formula cells, that control how the calendar view looks:
- Optional start date for the calendar.
- Leave it blank and the calendar will start on the week of today’s date.
- How many items to show per day (the sample uses 5).
- If you need more items per day, you’d need to make changes to the calendar sheet’s structure
- In the event list, which column number has the combined data? (column 4).
The formulas on the Settings sheet calculate the six-week range for the calendar, and the start date for each week.
- Note: The only thing you should change on this sheet is the Start Date cell. Leave the other settings and all the formulas untouched.
Step 3: See the Calendar View
After you enter your upcoming events, you can switch to the Calendar sheet. It shows your events in a six-week layout.
I like this view is great because it gives an ongoing look at upcoming events, for 6 weeks.
Here are a few key features of the calendar view:
- The current date is highlighted, so you can spot today’s events quickly.
- The first day of each month is highlighted to help you see month starts.
- Each day shows up to 5items.
- If there are more, the cell shows a red date with two asterisks to warn you there are extra items.
The calendar sorts events by time automatically. You can add events in any order on the Events sheet and the calendar will place them at the correct times for each day. This background sorting keeps the Events list simple to update.
Step 4: Add and Manage Events
To add an event, go to the Events sheet and type a new row.
For example, add today’s date, a time like “2:00 PM”, and a short note “Meeting”.
Switch to the calendar and you will see the event in the right spot.
- If you add multiple events for the same day, the calendar view will automatically sort them by time.
- If a day has more than five events, look for the red date with two asterisks.
- That tells you to open the Events sheet to see the rest of the items for that day.
Get the Excel Calendar File
To download the Excel Events calendar, go to the Excel Calendars page on my Contextures site.
The zipped file is in xlsx file format, and does not contain any macros.
_____________
Build a Daily Events Calendar in Excel
____________