Calendar Generators

[Pete_UK]

I've responded to many threads about calendars on Excel Forum, so I thought as we enter New Year's Eve it might help to put a few of them together in a series in the Tips and Tutorials Forum.

I wrote my first calendar generator program in the mid 1980s - it was in BBC Basic for a BBC Micro (ah, happy memories !!). It wasn't very interactive: the program asked the User for a year, which was validated to be between 1901 to 2099 inclusive, and the User could also specify whether to generate a print-out or not. In those days of dot-matrix printers, each line of print had to be generated and sent to the printer.

I chose a layout of two months side-by-side, with each month arranged with the days going across from Sunday to Saturday, so that the whole calendar could fit on a single page, and of course, the program coped with leap years within the range of years (chosen to avoid century-year considerations, as 2000 was a leap year but 1900 and 2100 are not).

Anyway, a few years ago I decided to try to reproduce that calendar in an Excel file, and that is my first attachment. All you need to do is enter a year in cell I9 and the calendar for that year will be generated automatically - you can then print it out if you wish.

Hope this helps (more to follow).

Pete

[Pete_UK]

The next attachment contains a sheet which is very similar to the previous one - enter a year in cell I1 and the calendar automatically appears. However, the formulae which generate the calendar are very different. I've not done much formatting to the sheet, allowing you to add your own colours and lines etc., but there is conditional formatting applied so that if cell I1 is blank the calendar disappears (and cell I1 is then coloured yellow).

There are two other sheets in this file, however - one shows three months going across, with four down, and the other shows four months across by three down - just different ways of showing the calendar, and each controlled independently by the year in cell I1. The latter two sheets are set up for printing in landscape mode.

Hope this helps.

Pete

[Pete_UK]

Okay, another example of this type of calendar is one where the months go down the page and then across, so very similar to the previous example except for that change.

I suppose I ought to point out that I am posting .xls files - these have been tested out on an old laptop which has Excel 2000 installed (and without the ATP), so these should work with any versions of Excel.

Anyway, there are many other types of layout, so I'll post a few more examples in the next few days.

Hope this helps.

Pete

[jaheen100]

This calendar creator generates a calendar with holidays for many countries. When created, the calendar shows dates for any year or month.

[nfinnemore91]

Pete,

I am having a hard time and was wondering if you could help me. I am trying to auto populate a calendar to show specific data inside the day.

Example I have a list with a "work order number" "description" "start date "finish date" "technician" "time as in 2x15.hr"

I would like each task in the calendar to say "work order number-description-owner- time"

Work Order Description Scheduled Start Scheduled Finish Owner Time
101900136 troubleshoot Jul 8, 2019 4:10:00 PM Jul 9, 2019 4:10:00 PM george 2x1.5hr
102266552 pressure Jul 8, 2019 6:57:00 PM Jul 9, 2019 6:57:00 PM bob 1 hr
102334705 leak Jul 1, 2019 2:22:00 PM Jul 1, 2019 2:22:00 PM rich 2x1hr
102343105 bad pump Jul 1, 2019 1:41:00 PM Jul 1, 2019 1:41:00 PM joe 3x3hr

Also if the start date and the finish date are not the same I would like to make it merge on the calendar if possible. I have been glancing through your sheets but cannot find something that will work yet.

[Pete_UK]

I've just seen this, so apologies for the tardy reply.

It would help if you attached a sample Excel workbook, and then I can incorporate it into one of my files.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do not try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete