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

  • I am not able to download the template. Also, I have some template ideas but I can’t see your email anywhere?

  • Hi, the links are not working – is there any way to still access this template? Thanks.

  • How can the task print on the calendar

  • Hi – The link is still broken. Anyway you can send me the template? Thank you!

  • Tom Wruble says:

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

  • The download link doesn’t work

  • I am unable to download your template with chrome or firefox. is there something I am missing?

  • Could you provide the link to download? The links on the page aren’t working


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

  • Kumara Kalatuarachchi says:

    hi I tried to download this but it is not downloadable

  • No puedo descargar la plantilla, ayuda!

  • Unable to download. Is it not working?? How can I download???

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

    • Dear Amit,

      would you share me the template please?


  • Dear Sr,

    I am unable to download . Would you please provide me the template.

    kind regards,

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

  • Hello,

    I am unable to download your template. Would you be able to provide a lead towards the coding? Thanks!

  • Amit Choudhury says:

    Unable to download the sheet

  • Saubhagya says:

    I am not able to download this file “A Calendar Integrated with a To Do List”
    Please help.

  • If I enter info on my phone, or computer or tablet will it go to all 3 devices automatically? TY

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

  • Jaka Strojansek says:

    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.

  • 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

  • It would be great, if you make a video on how to make this Excel template step by step.

  • How do you get the show monthly task list button done with window to popup?

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

  • ssemakula Uthuman says:

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

  • Freddy Rousseau says:

    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.

  • Hiba Hishi says:

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

  • Devang Mehta says:


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

  • Yika Riley-Smith says:

    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 says:

        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.

  • Yika Riley-Smith says:

    This is EXACTLY

  • What tool do you use to create gif images?

  • Gopalakrishna Rao. says:

    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

    • BIPRADAS DHAR says:

      please share me the Calendar Integrated with a To Do List

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

      • Snuppelura says:

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

  • Snuppelura says:

    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

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

  • >