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 *.xlsm file

This workbook contains macros and a custom function.

calendar-monthly-view.xlsm