customizable calendar events excel 2013 free download

Drag down a few hundred rows depending on how many dates you want in your calendar.

It is easy to add many dates to the calendar in no time, see steps below. The Calendar needs a record for each date or you won't see dates that have no events.

Press with left mouse button on OK to apply settings and create an Excel Table.

Press with left mouse button on check box 'My table has headers'.

Press with left mouse button on 'Table' button and a dialog box appears.

Type header names shown in the picture below.Create a new worksheet, I named my worksheet 'Data'.The steps below describe how to set up the data for the calendar. We will link the Pivot Table data source to the Excel Table in a later step. You will often add data to the calendar so the Excel Table will be a huge time saver. You need to adjust regular cell references when data is added or deleted, using Excel Tables make this problem go away.

They are called 'structured references' and don't change when data is added or deleted. The reason I am using an Excel Table in this example is that they are easy to reference. The following step describes how to convert the calendar data to an Excel Table. I saved my calendar data on another worksheet named 'Data'. The events and the dates are located on another worksheet in an Excel Table. There are no VBA macros or UDFs in this workbook, it is all powered by the Pivot Table and a few formulas. Above the calendar are two slicers, they allow you to select what year and month to show.Ĭalendar Events are displayed vertically to the left of the dates, duplicate events are merged into one distinct event. The image above shows the calendar with dates horizontally and month. The calendar is created as a Pivot Table which makes it lightning-fast and easy to navigate. This article demonstrates how to build a calendar in Excel. Author: Oscar Cronquist Article last updated on April 15, 2020

Customizable calendar events excel 2013 free download