Free Template – Working Calendar

Today, I celebrate (aka BeExcellence) reaching One Million views by…  not going to work (because typhoon is hitting HK).  😉

Thank you very much for visiting my blog in the past.  Every single visit and page view from you constitutes my little achievement here.

As a token of appreciation, I want to share a template of working calendar with you.

Here’s a snapshot of the calendar. 

Working calendar

It is a combination of natural calendar and retail calendar.  You may find it more relevant if you are working in a retail company.

You may input any notes in the “Input” sheet:

Working calendar - Input page

I believe this calendar is set up in a way that is easy to use.  Although the “Calendar” sheet is protected, there is no password set.  If you wish, you may unprotect the sheet and do the “reverse engineering” to understand how it works.

You may download the Free Template – working calendar here.  I hope you like it.

Again, sincerely thank you for visiting 😊


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in General, Template. Bookmark the permalink.

4 Responses to Free Template – Working Calendar

  1. Robert M says:

    Great calendar. When I input an event for the last day of the month, i.e. July, or August or October the event letters on the calendar for those days are white, not black. Apparently this happens for the last day of the month. Also how can I make the text on the calendar Bold? Thanks


    • MF says:

      Hi Robert,
      Thanks for your feedback. Please try to download the file again.
      If you wish to BOLD the calendar, just unprotect the worksheet and BOLD wherever you want. 🙂
      Have a nice weekend!


  2. FrankT says:

    Unfortunately, color coding does not work.
    Conditional formatting refers to “Table2” !?

    Liked by 1 person

    • MF says:

      Hi FrankT,
      Thanks for pointing that out. You are right, the conditional formatting refers to “Table 2”. Somehow, I changed the table name…
      Pls download the file again. That should work.


Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.