Article updated on February 02, 2018

Tesh asks:

How easy is it to modify this for recurring tasks (weekdays, weekly, monthly, quarterly and yearly) and maybe show a monthly view? Times are less important than just showing what is due on what day.

I made a calendar shown below, monthly view. The picture is resized to fit this blog, click to see the original size. This calendar is more advanced than the template I made year 2011.

Add event

The form next to the calendar allows you to add events. Enter time and event name and then click button "Add".


See all events on a specific date

If there are more events on a single day than can be displayed, the last line tells you ...more.... See picture below for an example.


Select that cell and all events are shown in a table next to the calendar.


Edit event

You can easily edit or delete an event by clicking a link in column Time, see picture above. The link takes you to the record on sheet "Schedule", see picture below.


Here you can edit or delete the record as you please.

Change month

The buttons above the calendar lets you go to next or previous month, there is also a button that takes you to the current month, button "Today"


Conditional formatting

Days before and after selected month are grayed out. Current day is highlighted orange. The following picture shows you this.


Recurring events

The best I could do is creating a formula that calculates the upcoming recurring event. Events after that are not shown until the date has passed.



Array formula in cell H4:

=IF(DAY(TODAY())>3, DATE(YEAR(TODAY()), MONTH(TODAY())+1, 3)+11/24, DATE(YEAR(TODAY()), MONTH(TODAY()), 3)+11/24)


Array formula in cell H5:



Array formula:


Anyone got a better idea?

Download excel *.xlsm file

This workbook contains macros and a custom function.


Big version

This bigger version has 10 rows per day.

Download *.xlsm file