Calendar Integrated with a To Do List Template in Excel

Starting this month, I have decided to create and share an Excel Template every month. I already have a ready-to-download Excel Templates section on this blog, and I will keep on adding these new templates to this section.

Before I come to this month’s template, I have a favour to ask. If you have any ideas for Excel Templates, do share it with me (email me or leave a comment below). It will help me create stuff that is useful for you and my other readers.

Also, if you are already using a template, and would like to share it with others (and get yourself featured on my blog), just email me or leave a comment below.

Now, here is the Excel Template Of The Month A Calendar Integrated with a To Do List

Calendar + To Do List Template

In December last year, I was working on creating a calendar template, but things got busy and it fell through the cracks. I picked it up again a few days ago. And this time, I got a bit aspirational and started working on a calendar template that has a to-do list integrated with it (a standalone calendar in Excel wasn’t making much sense to me).

With a bit of VBA and Excel Functions, I have finally created something that I think is worth sharing.

Click here to download the templateDownload File Pic

Here is how the template works:

  • Change month/year with a click.

Calendar cum To Do List Template in Excel - Calendar Demo

  • When you double-click on any of the dates in the selected month, it opens the Enter Task input box. Enter the task and click ok (or hit enter). Two things happen when you add a task:
    • The date for which the task has been entered turns blue.
    • The task for that date gets recorded in a separate worksheet.

Calendar cum To Do List Template in Excel - Enter Task

  • You can enter multiple tasks for different dates or the same date (I have written the VBA code to record up to 1000 tasks).
  • To get a list of all the tasks in a month, click on the Show Monthly Tasks List button.

Calendar-cum-To-Do-List-Template-in-Excel-Monthly-Tasks-List 2

  • All the tasks are recorded in the back-end (in the comments tab). You can delete the tasks when it is done, and it will stop getting reflected in the calendar.

Click here to download the templateDownload File Pic

How is it? Do you like it / hate it? I would love to know what you think.

Is there an Excel Template you wish existed? if yes, let me know, and you may just get it 🙂

Other Excel Templates You May Find Useful:
  • MF

    Interesting!
    FYI. A bug occurs for display task for month end. When I click “Show Monthly Tasks”, the task input for the month end date (if any) will fill up the message box…

    • Thanks for highlighting the bug.. I have fixed it and uploaded the revised version 🙂

  • Snuppelura

    hi, would it be advantageous to have the date in front of the task when clicking “show monthly tasks list”? The date should preferably show acc to locale settings. And being able to print the task list? What do you think?

    • Thanks for commenting.. I agree, date was something that should have been there. I have changed the template and updated the article. Now it shows the date. I also like the idea by Rich to show the list as soon as someone changes the month, and it would also be easier to print in that case. I will try and make that change too

  • Rich

    Agree with Snuppelura – needs the dates with the task on list – what if you have multiple tasks on a date, you would not know what dates went with what tasks???
    Also – why have the list as a pop-up, why not have the list dynamic based on the selected month/year and always shown???
    other than that – very useful and neat
    Rich

    • Thanks for commenting Rich.. Have changed the template so the date is now visible for each task. You have given me so many more ideas by mentioning the dynamic list. I will create a separate version and try this dynamic list thing in it 🙂

      • Snuppelura

        Good idea, and maybe the calender can default to today’s date?

  • Gopalakrishna Rao.

    I have downloaded, but it is not working? Anything to be enabled (Macros)? How to do it? Please explain in the video itself. Thanks a lot for taking more trouble in doing this

    • Yes, you would need to enable macros for this template to work

  • Kannan

    What tool do you use to create gif images?

  • Thanks for sharing.

    I would like to submit the Personal Finance Manager Excel template http://indzara.com/2013/05/personal-finance-manager-excel-template/ for your consideration. It’s free to download. If you think it’s worth sharing with your readers, please do. Thanks for considering. Best wishes.

    • Thanks for sharing.. It looks good.. I will soon share it with my readers

  • Yika Riley-Smith

    This is EXACTLY

  • Yika Riley-Smith

    This template is exactly what I need right now! However, when I try to open the downloaded file, I get: 1) Excel opens; no new spreadsheet or this template displayed; or 2) file corrupt. I am using Office 2013.

    • Hello Yika.. Are you able to open other Excel files? The download file seems to be working fine on my system.

      Try this: Open MS Excel, then drag this file and drop it on the open excel workbook. I have been facing the same issue with 2013, and this trick works for me.

      This contains macro, so you will have to enable it

      • Yika Riley-Smith

        Had no problem opening it at work in Office 2007 (or 2010, I don’t remember which). Although I need it for work, I had just wanted to use it here at home to try to get a start on it. I never was able to get it to work. Same problems.

  • James

    Hi there
    This is great. COuld oyu make it work the other way? I mean could I copy and paste a task list into the comments page and it transfer it to the calendar?
    That would be helpful for my task.
    Also it would be great to tbe able to print the claendar out with a list of tasks.
    Thanks!
    james

  • Devang Mehta

    HI I USED YOUR TEMPLATE AND SEEMS TO BROADLY COVER THE GENERAL OUTLINE OF WORKS TO BE DONE DATE WISE HOWEVER TIME FOR THE TASK IS NOT RECORDED HERE. BUT OVERALL ITS QUITE USER FRIENDLY

  • Hiba Hishi

    Is there any possibility to merge between Excel to do list template (drop Down) with the integrated calendar?

  • Freddy Rousseau

    Hi, that’s a good start. I think it could be interesting to add a daily workload. So that you can check if you overload your day/week/month.

  • ssemakula Uthuman

    Hello, thanks for this is exactly what i need right now at work.

  • Lauren

    This is great! But the dates aren’t highlighting when there is a task 100% of the time (I think this is because I have a very long list of tasks and it may be limited?) is there a way I can update this?