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 template
Here is how the template works:
- Change month/year with a click.
- 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.
- 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.
- 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 template
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:
52 thoughts on “Calendar Integrated with a To Do List Template in Excel”
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!
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
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,
Greetings!
would you share me the template please?
regards,
Dear Sr,
Greetings!
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!
Unable to download the sheet
Hi
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.
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
thanks
Declan
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?
Hello, thanks for this is exactly what i need right now at work.
Glad you found it useful!
PLEASE SHARE ME THE Calendar Integrated with a To Do List
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.
Is there any possibility to merge between Excel to do list template (drop Down) with the integrated calendar?
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
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
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.
This is EXACTLY
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
Thank you. Best wishes.
What tool do you use to create gif images?
I use Camtasia for it
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
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
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 🙂
Good idea, and maybe the calender can default to today’s date?
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 🙂