Excel Template Formula Issue

[jmluchare]

Hi Guys,

I am trying to edit this template, that uses macros, array formulas etc... and I am having no luck.

What I need to do is change the start month - whilst maintaining the auto-update of the dates in the calendar grid (so that I can continue to use it). My start month needs to be November.

I would appreciate any help you can give me.

Thanks

[Pete_UK]

I've posted a number of calendar generators on this forum - here's a link that will give you access to some of them:

http://www.excelforum.com/excel-prog...dar-dates.html

They all use formulae rather than macros, and enable you to take a list of activities in any order and position them in the correct location on a monthly calendar, which automatically adjusts - drop-downs in the calendar sheet allow you to select the month and year of interest, and you can have up to 7 (or 12) events listed in any one day. Perhaps you might find one of those to be more flexible.

Hope this helps.

Pete

[jmluchare]

Thanks for that! I will check them out now