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:

Excel Ebook Subscribe


Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

52 thoughts on “Calendar Integrated with a To Do List Template in Excel”

  1. When I try to download the Calendar + To Do List Template, I get an ERROR(404). Can you help me with this please?

  2. hi sumit
    please share me this Calendar Integrated with a To Do List Template in Excel i can’t download it

  3. Hi, I have one suggestion to in-corporate. In the To-Do list template some task do not complete on that particular date. So, if we can assign the pending task to some other date directly, it would be great.

  4. Need a template to record and keep track of the daily temperature of items, oxygen tank remaining values and sharps needle count of how many used today and also weekly calibration values, this is for a medical setting. The past data can be accessed for any point in time and who entered the information with assignable entry and editing privileges. 🙂 is that asking too much? 🙂

  5. Thanks. Can you please add a button to list out daily task list as well, in addition to the already existing monthly task list button.

  6. Hey, can I use this in my project management excel file? I tried copying the two spreadsheets (Calendar, Comments) in my file, but that doesn’t seem to work. Thank you for your assistance.

  7. Hi.
    would it be possible to have an excel template that has recurring tasks with a pop up reminder.
    For example: In a restaurant where cleaning tasks have to be done daily,weekly & monthly. could a template remind staff of the task to do and check it as completed then automatically renter into the task list again for the next time.
    hope this makes sense

  8. 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?

  9. 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.

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


  12. 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.

  13. 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

      • 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.

  14. 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

  15. 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

    • 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 🙂

  16. 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

  17. 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…


Leave a Comment