• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Expand Calendar to Display 6 Weeks

K

Karicula

New Member
I am using a Microsoft Template which works pretty well but I want to expand the display to show 6 weeks rather than just one month. The template has embedded formula names and I cannot figure out how to modify the formulas to display 6 weeks rather than one month. I really like the design of it because on the first sheet I can list a bunch of things with dates that I am planning to work on, but it stops at one month.

Any help or advice would be GREATLY appreciated! Thanks.
 

Attachments

I think there was only a few small changes to the Named Formula

The majority of changes were to the bottom two rows of dates as each cell had to be manually edited and array entered

The Conditional Formatting was quite messy and so that was a bit of work to tidy up.

I also added a new Conditional Format to highlight the months which aren't in the Selected Month
 
You must log in or register to reply here.
Back
Top