Forum Discussion
Creating your own Calendar Templates
AndrewPilcher I don't understand what you mean by fill alternating rows by week.
SergeiBaklan , Riny_van_Eekelen , I don't understand the point of that named value being a 2D array because the best I could tell it is only using the {0,1,2,3,4,5,6} first row of it.
EDITTED: deleted file and ref to it
Back to AndrewPilcher question, the way that template work is to create an ARRAY of 7 cells in a row to output a particular week. So cells B3:H3 are all part of week 1 of the month, B7:H7 are wk2, etc....If you want to skip more rows then just insert rows in between. If you want to skip weeks then just add to the "offset" being used in the calculation for each week. In template each week looks like:
{=DaysAndWeeks+DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),(WeekStart="mon")+1)+offset} where offset is 1 for wk1, 8 for wk2, ...
does that help?
AndrewPilcher DAYSANDWEEKS is not an Excel function. What templates have you been looking at and what do you want to achieve?
Thank you SergeiBaklan for the clarification. Can you make sense of how to get the array definition {=DaysAndWeeks+Today()} to fill alternating rows by week?
AndrewPilcher I don't understand what you mean by fill alternating rows by week.
SergeiBaklan , Riny_van_Eekelen , I don't understand the point of that named value being a 2D array because the best I could tell it is only using the {0,1,2,3,4,5,6} first row of it.
EDITTED: deleted file and ref to it
Back to AndrewPilcher question, the way that template work is to create an ARRAY of 7 cells in a row to output a particular week. So cells B3:H3 are all part of week 1 of the month, B7:H7 are wk2, etc....If you want to skip more rows then just insert rows in between. If you want to skip weeks then just add to the "offset" being used in the calculation for each week. In template each week looks like:
{=DaysAndWeeks+DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),(WeekStart="mon")+1)+offset} where offset is 1 for wk1, 8 for wk2, ...
does that help?
