Modifying Numbers calendar template - adding holidays & custom text

Changing the TEXT in the Months pop-up menu is easy See the right sidebar in the image below), BUT…

The monthname in that cell is used in calculating the dates in all three calendars on the page.

When I changed the English "January" to "Enero" (Spanish), the large grid placed the dates for December, and the smaller month-before and month-after calendars were populated with the correct dates for November and January respectively.

(The December calendar below the first week of the Pages template is from the Calendar application.)

Besides changing the month names in the menu cell,you'll need to change them in column B of the Month and Year table containing that menu.

Other changes may also be needed, but I've not explored further.

Regards,

Barry

I don't think a document based on the 'Calendar' template is your best choice to include holidays. Is there a reason you aren't using the Calendar app, which offers that, and many other features?

As for changing the month names in the Pop-Up Menu you can do that directly in the Pop-Up Menu itself (which you have highlighted in yellow in your screenshot.) Just double-click each month name and change it to whatever you want.

SG

carl907 wrote:

If i make a new table and manually enter holidays in a column A and holiday names in column B, how do I get them to show on the proper dates with text in the box?

Not possible, I think, without a complex script.

SG

If you must stick with the Calendar template because it has the appearance that you want then I think you will need to type the holidays in manually.

SG