display 6 weeks on TEMPLATES/ CALENDARS/ HOMEWORK CALENDAR

This calendar template displays one month and I want to expand it to display 6 weeks - however, the formula will not copy or update.  I attempted to modify the names in the Formula Name Manager but cannot figure it out - any help appreciated!

• Moved by Fei XueMicrosoft contingent staff Tuesday, March 17, 2015 1:16 AM

Hi,

It will be very helpful if you can provide me more details. The Formula used in calendars are different. Like some simply uses INDEX formula, but some uses combined formula like IF(DAY(JanSun1)=1,JanSun1-6,JanSun1+1).

Could you please help me with following informations:

1. Which version Excel are you using?
2. Which calendar have you chose?
3. What was the formula of your chosen calendar?

      It will be better that you send the calendar file you created to me by mail: ibsofc@microsoft.com .

Take Index for instance, if the first Calendar item in the table is = Index(calendar,ndx+0,1). Tt means that arrange is in calendar sheet, the row number of first Calendar item set NDX+0, column number is 1. So if its in the same row, you just add the column number by 1. If you move to next row, you add 1 to row number. Column number start from 1 again.