skip to Main Content

Dynamic Event Calendar

4.8 (10 reviews)

Interactive Event Calendar Template in Excel. Easily follow your events, organizations, meetings or todo lists. Print ready and easy to use.


Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Calendars are one of the most used and demanded template types in Excel. We prefer to have it in Excel because of easy editing and flexibility. Especially when it comes to event planning, a calendar makes it very easy to follow. However, making an interactive and dynamic calendar in Excel is not an easy task. We have built Someka Dynamic Event Calendar exactly for this purpose.


Dynamic Event Calendar Template Features:

The template consists of 2 main views:

  1. Calendar
  2. Daily Events

Basically, in this event calendar template, you will put in your events/organizations/meetings or whatever you deal with to the Daily Events View. And after that you can see the task details in a nice Calendar View of the template.

Just click a date on the calendar and the event details will show up on the left. See the template in action:


Besides that, when you use a static calendar in Excel, you have to adapt it for every new year. In this template, you can select the year and all dates will get automatically adapted.

Don’t waste time on dealing with confusing tools. Use this Event Calendar Template and focus on your event planning.

Disclaimer: The original design of this template belongs to Purna Duggirala, founder of We have used it with his consent and acknowledgement. You can click here to download his Free 2020 Calendar & Daily Planner template. He is passionately providing free Excel & Power BI Tips & Templates and awarded MVP status in 2009 by Microsoft.

Dynamic Event Calender Template Features Summary:

  • Dynamic Calendar Excel Template showing the event details on a calendar view
  • Allows you to select years and all dates are adapted automatically
  • Clear on-sheet instructions
  • Easy to use and nice design
  • Works on both Windows and Mac
  • Compatible with Excel 2007 and later versions.
  • No installation needed. Ready to use.
  • Print ready
  • White Label
  • Includes VBA code and macros

This Event Calendar Template is prepared with VBA macros. Don’t forget to enable macros after you get it.If you need customization on your reports or need more complex templates, please refer to our custom services.

If you like automation features of this template, you may want to check out this tool as well:


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



10 reviews for Dynamic Event Calendar

  1. Laura

    Perfect for what I’m after!

    Can you let me know please how I change the colour linked to the priority level when it shows on the dates in the calendar?
    I changed the colour in the key at the top however that’s clearly not where it’s linking to.


    • Someka

      Hi Laura,
      Thank you for your kind words.
      The colors on the Calendar are set by conditional formatting. Changing the colors on the key is not enough, you have to change it from the conditional formattting settings.
      Let me explain how to change your conditional formatting settings:
      After being sure that your sheet is unlocked, go to Home > Conditional Formatting > Manage Rules.
      Dynamic Event Calendar
      Select Worksheet from the dropdown to see all the rules, then select the rule you want to edit and click on Edit Rule.
      On the Edit Formatting Rule window click on Format button and then in the Format Cell window under the Fill area you’ll select the color you want to apply before clicking on OK.
      Dynamic Event Calendar
      Hope this helps!
      In case you still need help for changing colors, just let us know and we’ll help you to format your calendar according to your needs.

  2. Mona

    I loved it! very nice, how can I change the gray rows (weekends) to become on Fridays & Saturdays?

    • Someka

      Hi Mona,

      It’s good to hear that you love it! Our developer team has added conditional formatting inside the template to color it grey when the day falls on a weekend. So, if you would like to change the weekend days, you should rearrange the conditional formatting options from the Home tab > Styles Section. Hope that helps!

  3. Julie Shaffer

    I like how your Dynamic Events Calendar looks and I think it is what I have been looking for. However we do have multiple events sometimes on the same day (I am trying to use one calendar for events, webinars, podcasts, editorial due dates). How is that handled? It looks like this template only allows for one event per day. Is that correct?

    • Someka

      Hi Julie,

      First of all, thanks a lot for your interest!

      Actually, you can add multiple events to the same day by using a comma between them. But, we recommend doing this if all the events can have the same prioritization.

      The template will be more efficient when you use priority selection just for one event. On the other hand, you will only be able to see just one color in the calendar symbolizing the priority of the event for that day.

      Hope that helps!

    • Julie Shaffer

      Thank you for your quick response. Yours is the closest solution to what I’ve been looking for, which is place to detail all events, podcasts, webinars, and also our editorial calendar dates. I thought I could adapt this for all of those things, but it would require multiple lines to be seen on the calendar on one day for diverse projects. Do you do custom work?

    • Someka

      Hi Julie,

      Thanks again for your kind words!

      Yes, you can visit this page to learn our customization process: Hire Excel Expert

      Best regards,

  4. Hellery Jacinto

    i have question, when i input event example for May 1, 2019, when i change year to 2020 the May 1, 2019 still appear on 2020?
    everything works perfectly. just this one

    • Someka

      Hi Hellery. Glad to hear that the template is perfect for you 🙂
      Regarding the date change: yes, changing the year does not remove/add your own written words and data. (it would be confusing otherwise) If you want to manage two separate years we recommend using our template for 2019 and another workbook for 2020 (you can create as many workbooks as you want)
      Contact us if you have further questions.

  5. Roy

    I purchased the template. can i remove the someka logo?

  6. Tom

    Very good, but what happens if there are two events on one day?

    • Someka

      In Dynamic Event Calendar, you need to input separate days. Because when you input a new entry to the “Daily Events” section, they will appear on the calendar view. In dashboard, it paints the days with an event in it. And when you click on any painted day, it shows the details in a quick view box right side!

  7. KB

    I purchased the Dynamic Events Calendar to be able to track and also nicely present my two teams’ complex events in line with their requirements. I’m 100% satisfied with the product and it proved to be a great success with my team members. Customer service is exceptionally good and the agents are super helpful. I can highly recommend Someka! Thank you!

  8. Raju S

    Schedule in less than 1 hour. WOW! Thank you!

  9. dayrene costa

    excellent customer service. The agent was very helpful!! I am fully satisfied. Thank you

  10. Faisal


Leave a customer review

Your email address will not be published. Required fields are marked *