Apple numbers calendar template

Hi mc'

You have to remember that the Calendar template produces a spreadsheet document set up to display as a calendar. Behind the appearance, it's still a spreadhsheet.

That said, you could setup a three column table listing recurring events (column B), the day of a month they recur on (column A) and the amount involved (column C), then use a lookup function that reads the day value fo the cell it is in, looks up that number on the events table, and returns the name of the event and the amount, plus any fixed text you write into the formula.

There are several disadvantages to this compared with dong the same thing in Calendar:

You would need a copy of the formula in the 'notes' cell under every 'date' cell in the calendar.

Having the formula there would mean you would not be able to manually enter other events into the same cell. Entering date into the cell erases the formula, so the recurring events would no longer appear in that cell.

Events occurring at the end of each month would be difficult to handle, as not all months have a 31st, one does not have a 31st or 30th, and has a 29th only onece in four years.

Events occurring quarterly or semi annually would require a revision in the formula, and in the table, to accomodate.

The spreadsheet isn't able to send you an alert message on or prior to each event.

Regards,

Barry

Numbers is good for setting up budgets (be sure to check out the 'Personal Budget' template at File > New in your menu) but for reminders for repeat events have you considered using Calendar.app or Reminders.app? They are designed for that.

SG