2019 Calendar Templates

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

Hi apshaws,

You can create your own calendar in Pages or Numbers.

Here is January 2019. Type 1 into the cell for 1st January (Cell B2).

Formula in the next cell to the right (C2) = B2+1

Fill Right to G2.

Formula in A3 =G2+1

Formula in B3 =A3+1 and Fill Right to G3.

Repeat for other rows to get one month.

Repeat for other months.

If you want a year planner, (dates flowing down the page) that is also possible (and easy).

Please reply with your overall aim.

Regards,

Ian.

Hi Peter,

That Table should be transferrable to Pages?

The Numbers Calendar has four tables that depend upon each other and are necessary.

I used Numbers > Format Panel > Table > Tick Table Name

MONTH AND YEAR has a Pop-Up Menu format in A1 and a Stepper format in A2.

Neither of those cell formats exist in Pages.

2. Have Monday be the first day of the week

Yes, there was a discussion about that some time ago in ASC Numbers for Mac. The answer is simple, but I will have to search for that discussion because I don't remember the simple answer 😕.

What's in the hidden row 9 and how do you reveal it?

Click on a table to make it active.

Menu > Table > Unhide All Rows and Unhide All Columns

The quick answer to your other questions: Yes. The template seems complicated, but it is simple.

I will search for that old discussion.

Regards,

Ian.

Hi Barry,

Barry wrote: I haven't done much with tables in Pages, but fuzzy memory says they can't talk to each other.

I can't remember which version of Pages introduced the ability of tables to talk to each other.

Definitely works in Pages 7.1

Regards,

Ian.

Barry

That Table should be transferrable to Pages?

Also I am trying to understand the formulas and how they work.

The hidden line simply contains 1w in the Wed to Sat columns. What does that do?

I'd like to reconstruct the table to:

1. Be in a single table

2. Have Monday be the first day of the week

3. Include preceeding/succeeding months days (greyed out) to fill out the month block

Where can I find explanations and descriptions of how this and other interesting tables work in Numbers?

Thanks

Peter

Also is there a way to format weekend cells by formula in Numbers to be distinctive?

eg bold/color/background/border

…other than physically select and format them directly.

What's in the hidden row 9 and how do you reveal it?

A quick thanks Ian while I dissect this.

I had already copied the Numbers School Calendar over to Pages and it seems to work there so answered that question myself.

I understand the Pop-ups and Stepper cells aren't in Pages but regard that more of a UI issue than a functional one.

I examined the Year cells in the School Calendar and can not see how it makes the adjustment for the months that fall in the succeeding year. There does not seem to be a formula.

I must admit I have not made much use of Numbers because of its arcane UI.

Not that doing something different is inherently bad, just that before you can get anything done you have to spend a lot of time time working out how to do it, rather than just get on with it.

Peter 🙂

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

I found how the Table determines the first day of the week.

It is in the Hidden row's formula, 2nd cell: WEEKDAY | A9 | Monday is 1. But it seems the actual Day labels are straight text and not a result of the formulas.

This is where you go down the rabbit hole.

I already constructed quite a number of calendars, with all sorts of layouts, where the dates flow naturally and it is easy to follow what has been done without research.

Doing it more or less manually with a few simple formulas means you can't just shove in a far distant past or future year and have it adjust, but creating the initial calendar takes minutes instead of days.

I prefer my Calendars to be a single table because then I can click on the one Table and make straight adjustments such as Fonts/Size/Indents/Colors etc, stretching it all out to fit the space required.

Barry wrote:

I don't know if there is a reference site or manual. Might make for some interesting questions in the Numbers community

Regards,

Barry

Thanks Barry

I grabbed the entire Help site earlier in the year, with the intent of making a better more legible pdf manual, but Apple makes life harder and harder, by doing updates and improvements without saying what or where they are. You have to hunt through everything to see if they have or have not updated their Help (which has been the case previously).

Got there before you Ian 😀

Interesting is the way Apple has done this in the template.

You have to change the formula in every single Table for every single month. Not clear thinking IMHO.

Core Variables should always be linked to a single reference for obvious reasons.

Peter

btw I am not referring to the Single Month Calendar but to the Academic Calendar which shows 12 months spanning 2 successive years. The Single Month Calendar only shows one month and has to be duplicated to make a full calendar. Since this is a Template why not make life easier and actually have 12 months worth to start with, unless there is a problem with retroactively Styling the Sheets.

Hi Peter,

Numbers Calendar template.

I was confused until somebody (t quinn or SGIII or Barry) pointed out that it is a template for a single month.

In Numbers, duplicate that sheet 11 times to create a document of 12 months. Set the month of a sheet to January through to December. Not the Pages method, I know!

Regards,

Ian.

I'm progressively discovering this after I ask the questions Ian. 😉

Just amended my post above as I worked this all out.

As I commented: Why not provide a years worth and make the Styling work so changes are updated in all Sheets?

Apple has become terrible at explaining itself. How I miss the old Apple that understood that obviously people can't read your mind, you actually have to tell them, in as clear and straightforward language as possible!

There needs to be a dispossible Textbox with clear instructions for the less obvious details and what to do with the template.

PeterBreis0807 wrote:

Apple has become terrible at explaining itself. How I miss the old Apple that understood that obviously people can't read your mind, you actually have to tell them, in as clear and straightforward language as possible!

I am just endlessly repeating myself to no point because we know that "Your feedback is very important to us" really means "F.O.!".

It nearly always takes me 2-3 shots (or more) to actually get Help to show up, and having got it up all too frequently I get what I've just got now when I try to look up a specific topic (in this case Change the look of chart text and labels):

The selected topic is currently unavailable

So does anyone know how to make the Mortgage Calculator template chart (bar graph) $ start at zero, instead of just the top of the range?

Again finally got Numbers Help to show up and have answered my own question:

Select Table > Sidebar > Axis > Axis Scale > Min: change grey Auto to 0

By default it is always Auto and greyed out so it looks like it does not apply.