Editing Numbers Calendar Template for non-English language

You could do something like this:

Step 1: unhide all rows and columns in the first table Month and Year of the second sheet Monthly. Then do the following in that table:

• Change the English month names  to the Irish language in column B.
• Delete the text in column C.
• Add the number of the months from 1 to 12 in column C starting in cell C3. You will need these numbers of the month, instead of month names for the formulas to be used in cell C1 and in the first sheet YEAR.
• Select the twelve cells from B3 to B14 and format these cells as  Pop-up menus.
• Copy cell B3 and Paste this cell in cell A1; hence you will have the Pop-up menu in cell A1 in the Irish language.
• Enter the formula in cell B1:  = A1  (this value will be used in cell A1 of the first table of the first sheet >>> see step 2).
• Enter the lookup formula in cell C1: LOOKUP(A1;B3:B14;C3:C14). The result is the number of the month (this value will be used in cell A9 of the first table of the first sheet and in cell A1 of the following tables of the first sheet >>> see step 2).

Step 2: unhide row 9 in the first table Month 1 of the first sheet Year

• Enter the formula in cell A9: DATE( F$1;Month and Year::C1; 1). The result is the first day of the month chosen in the second sheet.
• Enter the formula in cell A1: INDEX(Month and Year::B3:B14; Month and Year::$C$1). The result is the month chosen in the second sheet.

Step 3: in the tables Month 2, Month 3, … Month12 enter the following formula in cell A1:

INDEX(Month and Year::B3:B14; MONTH(A9))

Paul.

Maybe you got the syntax error by using the " ; " instead of the " , ".

In Belgium we use the " ," as the decimal point and the semicolon " ; " for separating the arguments in the formulas.

If you use the "." as the decimal point in your region, you have to use the " , " for separating the arguments in the formulas.

In the previous post I forgot to mention the last step: to hide the columns and rows again.

Paul.