This is a monthly calendar that you can use for any year. It has three-month display in one page if you plan to print it and make it for your calendar reference. You can set the first month of each page before you print it.
There are three different models available for year 2020. The first model only has dates with blank notes at the right side. You can set your year, print and keep it for writing your agenda manually.
The second one has list of events table. There is an automatic date event insertion function that will place your important dates that you type in event columns at the left side of the worksheet into respective date and month boxes. You can see until 3 events in each date boxes. If you type more than 3 events in event columns, only the first three that will be shown in the calendar. You don’t have to type or arrange your event dates in order. The excel formula inside the calendar will find the dates in the column automatically.
The third one has a layout like the image you see above. Big dates. One single event space below each dates. And simple color marker. Those events are coming from list of events in separate worksheet. Type your events and the Excel formulas will place them automatically.
This calendar should suit you who has uncertain events or just want to arrange an event and try to find the most suitable date for it. With this single column event customization, you can change the dates and see it revealed in the calendars without moving its description to designated dates.
Monthly Calendar - 3 Month per Page (25.7 KiB, 2,797 hits)