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?
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?
- Thank you, I did not realize these were similar defined names with different formulas in the various workbooks.
I have no pre-DA Excel to test, but named arrays shall work natively in it, i.e. without CSE. And sure it returns 2D array in DA Excel.
