How can I locate the "Month and Year" sheet in numbers Calendar Template?

I've had a second look at this after I realized you were using the 'Academic Calendar' template and not the 'Calendar' template. There's a simple fix that allows you to copy the tables wherever you want.

'Month and Year::A3' is always 1. This stands for 'Sunday is 1' in the WEEKDAY formula.

So all you need to do is unhide row 9 in each table (the way you have done for June in your screenshot).

Then double-click cell B9 to call up the Formula Editor, click once on the 'Month and Year::A3' oval address token to select it, type 1, and hit return.

The formula should now look like this:

Repeat this for each table month. Then hide Row 9 in each table.

Now you can click the sheet name at the top (Year), choose Copy Sheet from the dropdown, click any sheet name in your destination document, and choose Paste Sheet from the dropdown. From there you can copy-paste the tables elsewhere in your document if you wish.

The whole process took about 5 minutes.

SG

Not a sheet, a table. On the Monthly sheet, the month and year you see in the top left corner are in a table named Month and Year. It has 13 rows and 8 columns of which only two rows and one column are showing, the rest are hidden. That particular cell you are looking for, A3, has the number 1. In the WEEKDAY formula, the 1 means Sunday is the first day of the week.

Further to what Badunit said:

The full address of cell A1 on a table in a Numbers document is Sheetname::Tablename::A1

f the formula referencing that cell is on the same Table as the referenced cell, only the cell coordinates ( A1 ) are needed.

If the formula is in a cell on a different table, the referenced cell's tablename will be required, and the sheetname may be required.

If the table containing the referenced cell has a name that is the same as the name of one or more other tables in the document, the Sheetname of the referenced table will also be needed; if that table's name is distinct from the names of all other tables in the document, it's Sheetname is not required.

You can always enter a cell reference using all three parts if the cell's full address. Numbers will automatically drop the unneeded parts.

For shorter formulas, give each table in your document a distinct name (and keep those names short).

Regards,

Barry

It's an ingenious template!

Here's a picture of what you are looking for. It will be easiest to keep copy the whole table because the formulas in it interrelate:

SG