I'm building a diary using Numbers, and want to make 12 groups - 1 for each month - that I can synchronise and repeat each year following. It's primarily on my iMac, but I'm synchronising it with my 1Phone and 2 iPads.
Hi Nigel,
In Numbers, see if this idea suits your needs.
13 Sheets in one document.
The first Sheet (named Year) contains a single-cell table where you type the year.
The second Sheet is named January. It contains one table with a Header Row and 31 Body Rows.
In cell A1, type the name of the month formatted as Text.
Formula in A2 (and Fill Down) =DATE(Year::$A$1,MONTH(A$1),ROW()−1)
For the screen shot, I hid some rows.
Duplicate the January Sheet 11 times.
Change the names to February, March etc.
Type the name of the month in A1 of each Sheet (as Text).
For each 30 day month, delete the last row (it will show the 1st of the next month and is not needed).
February is a special case. You need 29 Body Rows to allow for Leap Years. In non Leap Years, it will show 1st March. If you can just ignore that, all is good.
Change the year on the "Year" Sheet to 2020 and February correctly shows 29 February.
There are no links between months; they are independent. The only link between Sheets is to the "Year" Sheet to look up the year.
Regards,
Ian.
Hi Nigel,
In Numbers, see if this idea suits your needs.
13 Sheets in one document.
The first Sheet (named Year) contains a single-cell table where you type the year.
The second Sheet is named January. It contains one table with a Header Row and 31 Body Rows.
In cell A1, type the name of the month formatted as Text.
Formula in A2 (and Fill Down) =DATE(Year::$A$1,MONTH(A$1),ROW()−1)
For the screen shot, I hid some rows.
Duplicate the January Sheet 11 times.
Change the names to February, March etc.
Type the name of the month in A1 of each Sheet (as Text).
For each 30 day month, delete the last row (it will show the 1st of the next month and is not needed).
February is a special case. You need 29 Body Rows to allow for Leap Years. In non Leap Years, it will show 1st March. If you can just ignore that, all is good.
Change the year on the "Year" Sheet to 2020 and February correctly shows 29 February.
There are no links between months; they are independent. The only link between Sheets is to the "Year" Sheet to look up the year.
Regards,
Ian.
Wouldn't you better off with Day One or another diary app?
Even the Notes app. It works well with Apple pencil.
Either of these options seems more suited than Numbers to keeping a diary.
SG
My first thought was, "why not use Pages for a diary?" It allows you to do chapters like in a book and have them assembled all into one "book".
But perhaps you are making a diary of numeric values, etc?
I was looking at making 1 sheet per day, but that would mean making 365 separate sheets. So I wondered about making 30 separate sheets into 12 groups - 1 for each month. I'm still thinking about doing this in Pages - I started doing it this way following a daily schedule template idea in Numbers which I thought might give me the ability to put a new date in each page using a macro, or each time I started a new sheet for each day it would automate the sheet naming with the particular day etc, but I couldn't figure out how to do this. The advantage is that I can use both keyboard and Apple pencil, and share it across all my Apple devices. It works very well in that sense. Also I can make it searchable this way.
This is a good idea, but what I am trying to do is emulate a traditional diary with 1 day per page. I've designed the page, and at this stage have 1 spreadsheet per month with (approx) 30 sheets in each for each day. I've started copying each spreadsheet for each month, so now I have 12 separate spreadsheets, which I can keep adding to as I roll over each year. What I would like to figure out is an overarching environment in which they can all be coordinated - whether I would do that in Numbers, or Pages, or something else?
Wouldn't you better off with Day One or another diary app?
Even the Notes app. It works well with Apple pencil.
Either of these options seems more suited than Numbers to keeping a diary.
In British English, "diary" can mean a daily planner, not necessarily a journal. So, if you ask a friend if they are free for lunch a week from next Tuesday, they might say, "I don't know. Let me check my diary".
Hi Nigel,
Do you want the diary as one year on one sheet, or one sheet per month (12 sheets)?
Both are possible.
Regards,
Ian.
I'm building a diary using Numbers, and want to make 12 groups - 1 for each month - that I can synchronise and repeat each year following
