You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I wanna make a calendar using the calendar template available in Numbers, but it insists on starting the week with a Sunday. Can I change that somehow?
I've already setup Monday to start the week in the general settings and in the Calendar app settings but that doesn't do much in Numbers.
MacBook Air (13-inch Mid 2013)
What works here is this (assuming you are using the template for Numbers 3):
Add a column at the right by clicking the symbol by the arrow in this screenshot:
The dates in the new column will fill in automatically. Type SUNDAY in the header of the new column.
Then hide (don't delete) the original SUNDAY column on the left.
That's it!
The steps are similar for the little calendars upper right, except that to hide the original Sunday columns there you need to first unmerge the cells in the header of each of those tables (select the header and choose 'Unmerge Cells' from the Table menu). After unmerging, drag the formula in A1 over one cell to the right and then hide column A. And finally select the cells in the header and merge again.
A lot of the math for the calendar, if you're curious, is in hidden rows and columns in the table on the upper left that displays the date and year. Unless you are a lot better at calendar math than I am, best not to mess with it, though.🙂
SG
Hi jjfermine,
I see what you mean.
Hmm... more brains needed 😕.
Regards,
Ian.
Amazing! This worked beautifully.
Thank you!
Hi vesterberg,
Glad to do it. It was fun to figure out. That solved it for you?
quinn
Yeah that solved all of my problems, thanks again!
Hi vesterberg,
You are most welcome.
quinn
Hi SG,
This is why I like this forum. Interesting puzzles and then I learn something unexpected. It will be interesting to apply the sensibilities shown here to other projects.
quinn
Nice piece of detective work, SG!
Regards,
Ian.
Thanks, but there isn't anything to unhide - it's all visible, & I don't get the view you show.
Then how about posting a screenshot of the view you do get?
SG
When I add an info to a day in "January" for example, it duplicate to every month of the year. How to remove that?
Hi there, hope you can help.
When I add an info to a day in "January" for example, it duplicate to every month of the year. How to remove that?
Hi jjfermine, it's hard to know what you mean. Can you provide more details, perhaps a screenshot?
SG
Thanks, SG.
I can work with that.
Hello,
Actually this was *very* helping!!!
I played a little with the functions and understood the meaning of each cell in the mysterious "MONTH AND YEAR" table.
This is what I got:
Calender template in Numbers, start the week with Monday
