Author: Oscar Cronquist Article last updated on December 23, 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.
calendar-monthly-view

Add event

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

calendar-add-event

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.

calendar-many-events

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


calendar-many-events1

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.

calendar-edit-event

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"

calendar-change-month

Conditional formatting

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

calendar-conditional-formatting

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.

calendar-recurring-events

Monthly

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)

Weekly

Array formula in cell H5:

=TODAY()+IF(WEEKDAY(TODAY())<=3, 3-WEEKDAY(TODAY()), (10-WEEKDAY(TODAY())))+15/24

Daily

Array formula:

=TODAY()+17/24

Anyone got a better idea?

Download Excel file through email

Enter your email address to receive the workbook. Note, an email will actually be sent to you.
* You will also get a weekly newsletter, unsubscribe anytime!

Big version

This bigger version has 10 rows per day.

Download Excel file through email

Enter your email address to receive the workbook. Note, an email will actually be sent to you.
* You will also get a weekly newsletter, unsubscribe anytime!