Simply replace “Sunday” with “Monday”, “Monday” with “Tuesday” and so on. That’s because we updated the days without updating the order of the day names. Now, if you look at your calendar, you’ll notice that it’s no longer correct. In this formula “1” means the week starts on Sunday, while “2” signals the week begins on Monday. Why? Without getting too much into specifics, this value is used in a formula in a row below. Once these hidden rows are visible, we have to change the value of “Row 3” from 1 to 2. The following image will illustrate this process better. Clicking on that arrow will make a pop-up menu appear. Moving your mouse over the row numbers should reveal a small arrow. This should make the row numbers visible. If you began updating your calendar template by changing the colors or fonts, remember to make a copy of you work so you don’t lose it in case something goes wrong.įirst we need to uncover a bit of the “magic” of how this template works. The good news is that it’s possible to achieve this, the not so good news is that it takes a bit of work. I recently received an email from a reader who was wondering how to make Monday the start of the week in the Numbers calendar template. UPDATE: Numbers Calendar With Weeks Starting On Monday And that’s thanks to Apple providing a calendar template. Like I mentioned in the beginning, it’s not too much work to make a calendar in Numbers. I customized my calendar to make it more printer-friendly. Now you probably noticed that the calendar has updated automatically. Next, double-click on the year to edit it. Then, click the arrow and choose the month you want from that drop-down list. An arrow pointing down should appear on the right. But we can easily update those values.įirst, click on the month name. In my calendar template, the default year and month are not current. Click on it and follow the instructions in the previous paragraph. In the drop-down you should see “New from Template Chooser”. Tip: If for some reason you don’t have a “Choose a Template” window when you open Numbers, the simplest way to get to it is to click on “Help” in the menu bar. Then click on the “Calendar” template which should be the first in the list. In the “Choose a Template” dialog window scroll to the “Personal” section. There are many ways to make a calendar on a Mac, but this is one of the easiest ones. This is a quick tutorial on how to create a calendar in Numbers for macOS.

Calendar for macbook air