Birthday Calendar / Appointment Calendar

[EatMoreBacon]

Attached find templates for a birthday \ appointment calendar...

A very simple basic one done only with Excel \ Libreoffice

Extremely deluxe calendars designed with a data merge into Affinity Publisher.

Attached are templates for

monthly calendar

Monthly Planner

six months on one page

twelve months on a large page

Would be glad to hear suggestions for improvement.

Thanks!

DIY Birthday and Appointment Calendars.pdf Monthly Calendar template.afpub Monthly Planner template.afpub six month template.afpub twelve month template.afpub

Calendar Worksheet, legacy.xlsx Calendar Worksheet, libreoffice.ods Calendar Worksheet.xlsx

Edited December 12, 2023 by EatMoreBacon
fixed several glitches on the worksheets

[UnCommonGrafx]

Hi,

I am using the above worksheet and hit a problem. As I see no discussion on this, I am wondering why it is showing up for me. Using LibreOffice and the .xlsx format for its flexibility.

On the options page, when I change the year to 2025, I start getting errors down the stream: whole months disappear - Err: 502 replaces the start ofthe following months: February, March and June. Strangely, this does not continue through the rest of the months.

On the Merge sheet, make the following changes.

What I found to fix the errors is to change 01/01/1900 to 12/31/1899, in cells C2 and C32

After this, all dates show up and the file works a treat in Publisher. 

However, the Calendar sheet still does not resolve, showing err:501 in all spaces, but year and month.

(=calendar) in B3 seems to be problematic. How to fix?

 

[EatMoreBacon]

Are you using the calendar worksheet, legacy? I don't think the other one will work on LibreOffice

[UnCommonGrafx]

Hi,

I am using both of the other two. 

I will give the legacy version a shot. Thanks for the response.

 

Edit: 

The Legacy file is legacy for a reason. Haha. It's a no go. As well, I see in that file that the fix I've  applied is the same it uses. As well the legacy file is missing the months_merge sheet. 

 

My fix does mess up a thing or two. Seems it causes the mini calendars to be offset by one month, when merge, but displays the proper month.

Edited November 12, 2024 by UnCommonGrafx