How To Make A Calendar In Excel 2024 For Unlimited Years [From Scratch + Free Template]

In this training, we create the Ultimate Excel Calendar Template with unlimited calendar items, unlimited years along with a fully customizable calendar including a dynamic start weekday and dynamic coloring. We start with a blank worksheet and create this incredible template during the video, along with all of the VBA Code.

⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:

GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• Recurring Calendar Items
• Send To Outlook
• Simplified Day Formula
• Print Calendar
• Drag & Drop Items
• Month & Year Summaries
• Up To 10 Calendar Items
• Updated Time Formats
• Selected Item Color

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:38 – Overview
4:18 – Designing Main Screen
56:38 – Refresh Calendar
1:18:23 – Calendar Item Select
1:21:10 – Load Item
1:23:46 – New Item
1:25:06 – Save and Update Item
1:30:57 – Delete Item
1:35:02 – Previous Month
1:37:28 – Next Month
1:39:33 – This Month

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin

#ExcelCalendarTemplate2023 #FreeCalendarTemplate2023 #ExcelCalendar #FreeExcelCalendarTemplate

[robertbateman]

I made my calendar using the day and items as one string with vblf. I also used advanced filter to get monthly items. I added different fill colors for appts or events for my wife or myself. Birthday days get a picture of the celebrant in the lower left-hand corner. Navigation is very similar to yours. It hangs on the refrigerator door with magnets. I do love the way you created the days and colored them accordingly. Now, I get to merge the two. It gives this retired man something to occupy his mind. Thanks for all the tutorials that you give. You really are the best!

[keitamoussa]

Can't wait Randy !
I venture to say that my excel career without your comprehensive trainings would be way TOO HARD.
I still hope to learn a lot from you.
Keep it up Mr AUSTIN.

[joelabacherli]

Another awesome project. Thanks so much Randy. I made a few additions to my personal calendar. I split the tasks into 2 categories each with their own sub categories. I also added a couple dynamic fields to show pending or unfinished tasks. (FILTER is the best new formula!) Different colored boxes depending on their status. Also a button to send an email to the administrator responsible for QCing the task. This one is so much fun to use. I get ideas for additions almost every time I fire it up. You’re the man. Thank you for the content. Best on YouTube by far.

[kabar_baik]

If possible range date include text i think more power full. Great work Mr Austin All of your creation is impressive.

[stuartpool]

This is absolutely amazing! I had no idea the capabilities of Excel such as this. If I may Ask, I am trying to use this to crate a calendar to track monthly budget items and bills rather than appointments, under the Calendar Items sheet, is there a formula or way of setting Calendar Item dates as recurring on a specific day of the week/month/or EOM? Happy to support your patreon for any tips or tricks on this usage of you calendar.

[fritz-gvalcin]

I really love what you are doing ! Congratulations genius !

[balochzaicoding]

I really love what you are doing ! Congratulations genius ! very interested video

[MrTosha]

Great work again, would it be possible to add some sort of audible noise to remibd you of what you set.thsnks

[brucemoore]

This is extremely helpful. What if I have an event that extends over multiple days? over an event that repeats?

[sasifexcelsolutions]

4am in the morning here is South Africa, notification on, 😅😅😅

[DesmondMcClinton]

Great work! I'm making this calendar.. How did you get the color theme on the Admin sheet cell F7 under Cal.Item Color

[TheChinchu]

Hi Randy! I've watched this and the task manager tutorial to make a calendar for a friend who still uses a paper agenda and it was really helpful. Especially considering I had never written a single line of code before. They're both excellent and I have almost finished it. I have one small issue. My friend is a teacher, and it would be amazing if she were to be able to schedule recurring events. I know you did something similar for the task manager, but I don’t think it worked with the following example: “Give classes to Laura” every three days for the next three months. I don’t know how to calculate the skip or the end date. I hope you can help with this. Thank you very much for your trainings! I really like them.

Thanks for this tutorial. Trying to figure out how to make it where an event has a start date and an end date, so I want it to display across multiple days. So, it’s almost what I need, but not fully there just yet,

[seanheary]

This tutorial is incredible, thank you for sharing - it's sparked a whole new interest in Excel for me.

I've been trying to figure out how to sort events that last all day, or don't have a specified start time. When I enter them as 00:00, the cell goes blank - and when I changed the data validation to "All day", Excel sorts this after the valid times (so All day items display below the items with actual start times, I want to show the All day items on top). Is there a way to do this? Thank you

[heljodedor]

Randy, thanks for share all your knowledge and skills.

[debbieschroeder]

Good Morning. I am starting to set up my excel calendar, but I need help setting up the admin sheet within the work book. Which video should I watch that will walk me thru the process. Thanks,

[jspnl_]

This was a great workout. 👍
I Have a question for you
Could we highlight the cells of the current day in the calandar?

[dalehallam]

Randy,

Thanks for these wonderful Excel workbooks and training. I am working on the Excel Calendar workbook I wanted to add addition items under the Calendar Items table. I am trying to make this into an Emergency Management Exercise Scheduler.
The current Excel Calendar has Item Name; Item Date; Time; Duration; and Notes. I wanted to add 4 additional fields, Type of Exercise (dropdown), Facility Type, Category and Status.
I have tried to expand of the current fields to include the additional fields, but I get an error, Runtime Error 1004 -the extract range has a missing or invalid field name.
I have persed trough line by line in the editor but I am lost and can not see where I made the mistake.
Any assistance would be appreciated. Thank You Dale

[jorgeortiz]

Great template Randy! I was thinking on adding the name of the holiday. Also, is it possible to create a list with our family birthdates?
Could you please help me on this?
Keep up the good work.

[rosemarieorapa]

i am really excited for these another template to learn