Excel's Magic Calendar

[djl0525]

For over a decade I've missed two things in Excel. (Okay, I've really missed more than two, but this post is about the two that are on my mind at this moment.) One, a ruler like in Word and PowerPoint. And two, a Make Calendar button that lets you select a list of events, dates in the one column, text in the other column, and when you click the magic button it displays the list in a calendar layout. I see they added the ruler in 2007. Yipee! I'm still looking the magic Make Calendar button??? (I'm not looking for a blank calendar... I've seen the templates.) I want to turn my list into a calendar.

What are your favorite ways to calendarize Excel data?

--DJ

 

[GuardianEnzo]

Thanks a ton Perpa, really appreciate the speedy feedback.
I implemented your new code and I was able to get the macro/calendar to function properly.

However, shortly after I closed out of the excel sheet and reopened it I seem to be getting a "Type 13 mismatch error" on this line:

d = Application.Weekday(Cells(4, 6) & " 1, " & Cells(4, 8))

This is very confusing as it was working fine before. I will likely just take your template and start again from scratch and see if I can reproduce this issue, but if anyone had any insight it would be greatly appreciated.

 

[GuardianEnzo]

Sorry for the spam but I figured it out (cant seem to find the edit post option)
It seems this was a problem with excel itself, restarting the computer seem to fixed this problem.

 

[Perpa]

I checked the Box.com link and it works fine. However, for those who prefer not to venture to that link, I am posting an image of the Calendar spreadsheet.
Perpa


Monthly Calendar with User Populated List of Dates - Album on Imgur

 

[Perpa]