2019 Calendar Templates
Where can I find 2019 Calendar Templates?
MacBook Pro
Are you willing to pay for them?
Question marked as
Look in the Template Chooser in Numbers for a Calendar template.
Version 5.6.2 has a one month calendar which requires only editing the year and choosing the month from a pop-up menu, Duplicate the single sheet to produce as many months of calendar as you want.
The sheet contains four tables: the entry table, when the year is entered and the month is chosen, does the set-up math in several hidden rows and two hidden columns, to determine the starting weekday and ending date of each or the three calendars displayed. The three calendar tables take it from there.
The Numbers 5 template also provides a blank calendar form on a second sheet. This sheet does not include the two smaller calendars, the hidden rows of the entry table, or any of the formulas used in the tables on Sheet 1 to fill the calendars on that sheet.
Your version of Numbers likely contains a similar template.
Regards,
Barry
20 replies
Works great. Thank you.
Still in Numbers v5.1 too.
Hi Peter,
Short answers:
That Table should be transferrable to Pages?
The template's Month Sheet has four tables. The two smaller ones, showing 'last month' and 'next month' could be omitted. The Month and Year table (displaying those two values) has two hidden columns and 12 hidden rows. At first glance these rows appear to be used by the two small calendars. If so, they could also be omitted, and the table joined to the main calendar table. I haven't done much with tables in Pages, but fuzzy memory says they can't talk to each other. If true, 'a single table' rises from a 'like' to a 'need.'
Pop-up menu and Stepper cells in Month and Date table would become 'ordinary' cells as these two formats aren't supported in Pages
Also I am trying to understand the formulas and how they work.
Me too. May get a chance to look more closely later in the week.
The hidden line simply contains 1w in the Wed to Sat columns. What does that do?
Hidden row? Hidden column? I don't see any beyond the ones mentioned above. Perhaps Apple has changed the calculations between 3.6.2 and 5.1 versions of the Calendar.
I'd like to reconstruct the table to:
1. Be in a single table
See notes above.
2. Have Monday be the first day of the week
Should be possible. The WEEKDAY function offers a choice of which day begins the week.
3. Include preceeding/succeeding months days (greyed out) to fill out the month block
That's done in the 3.6.2 version. Grey text is a conditional format setting for cells in the first row and last two date number rows in the calendar. First row: Date is before first of the current month. Last two rows: Date is after the last day of the current month.
Where can I find explanations and descriptions of how this and other interesting tables work in Numbers?
I don't know if there is a reference site or manual. Might make for some interesting questions in the Numbers community
Regards,
Barry
2019 Calendar Templates