Numbers 2023 Calendar
Is there a template for numbers allowing a 2023 calendar of Thursdays only?
Question marked as
Easy enough to create one from a blank table template.
Open a New Numbers document using a template that places one empty table on the sheet.
If you already know the date of the first Thursday in 2023, enter that date using the format you want to use in the final product.
If you don't know that date, enter the first of January in an all digit format, such as the one below:
Then, with that cell selected, click the Format brush to open the Format Inspector, set the cell format to Date and Time, using a format that includes the name of the day, and does not include the Time value.
Click in the cell containing the date, and reset the day value to the first Thursday of that year:
When you press return, the edited date will adopt the format you have set.
In A3, Type an = to open the Formula Editor, and enter the formula: A2+7, and tap return to confirm the formula.
The formula will get the value (and its format) from A2, add 7, and display the result using the copied format.
over the pointer ner the bottom of A3. When the Fill control (yellow circle shown above) appears, grab it with the pointer and drag down to fill the formula into as many cells as needed to get to the last Thursday date you want on the calendar (presumably the last Thursday in December, 2023).
While this fills in all of the dates, it also leaves them in a somewhat precarious position. Each of the dates, except January 5, depends on the formulas above it in the column and the date in A2. If any one of these cells is deleted or damaged, all of the dates below that cell will be changed or destroyed.
To avoid that, do this:
Select cells A3 (January 12) to A53 (December 28).
Press command-C to Copy the formulas in those cells and the dates they have calculated.
Go to the edit menu and choose Paste formula results.*
This replaces each of the formulas with the last result it calculated, making all of the dates 'entered' values rather than values dependent on a formula. Damage to or deletion of one of the values will then have no effect on the other values in the column.
That pretty much covers the question of placing the dates on a Thursdays only Calendar. The rest is just a matter of setting up the rows to the right of those dates to handle the data you want there.
I'll leave that part to you.
Regards,
Barry
* The keystroke combination for Paste formula results is shift-command-V
