Calendar

Question

I'm going to try this request again. Several weeks ago I sent in this problem and a couple people responded with solutions. It is an old excel spreadsheet but it worked for our small volunteer library. Recently I noticed that it was not populating cells in future months nor setting them up with correct dates. I'm open to other solutions if this one doesn't work for me. Please advise.

Thanks,

Jim

riny_van_eekelen · Answer

jimb390&nbsp;I believe I was involved in this at the time, though a bit longer than a few weeks ago. Anyhow, what exactly is the problem? When I select a month in the future, e.g. August 2024 the first day is on a Thursday, which is correct according to my calendar.&nbsp;

jimb390 · Answer

I see the problem. On the August calendar it didn't populate 8/31. When I bring up September, it populates the days before the month starts thus throwing off the entire month.

riny_van_eekelen · Answer

jimb390&nbsp;Not sure I follow. Tested several months. All seems to work fine. If you experience something different, please include a screenshot demonstrating the problem.

jimb390 · Answer

Here are the two screen shots. The August schedule doesn't have the volunteers that are suppost to work on 8/31. It's blank which is a problem. The September schedule starts by placing names in squares before the start of the month. This then causes all the names to be placed in the incorrect place in that month. I need to have it populate the squares at the beginning of a paricular month so that the names don't get shiffed.Jim

riny_van_eekelen · Answer

jimb390&nbsp;Okay! Now I believe we are back to square one. In an earlier thread I believe I mentioned that this particular template is quite useless. All it does is create a grid for the month selected, just like a good old paper calendar. It has no intelligence built-in that keeps track of activities/event in a particular month.&nbsp;You type in the names of the volunteers yourself one month, in the correct cells and next month you have to move or re-inter the names into the correct cells manually. There is no automated process here.&nbsp;Now, I do notice that there seems to be some kind of repetitive structure in the schedule. For instance, Wolf always has the 11am-1pm shift on Saturdays. Stoner, Elliot and Vultaggio seem to work as a team on Tuesdays and always taking shifts in the same order. These are just a few examples.&nbsp;Can you confirm or clarify how the schedule is made?&nbsp;&nbsp;

Forum Discussion

Calendar

7 Replies

Resources