Calendar in Excel

What Is Calendar In Excel?

The Calendar in Excel is a feature that represents a day, date, month & year. The function provides a calendar layout for specific needs. There are many varieties of calendars, ranging from an academic calendar to social media calendars in Excel.

Key Takeaways
  • The Calendar is made using the templates made earlier in Excel. From the “File” tab in the “New” option, enter the “Calendar,” all the templates appear, and we can choose any from them.
  • The other way to enter the Calendar is use Excel to make a custom calendar.
  • The “Microsoft Date and Time Picker Control 6.0 (SP6)” is only available on 32-bit Windows; it is not available on 64-bit Windows, so we cannot use it on 64-bits.
  • The Third-Party External Add-ins Tools is used in Excel for 64-bit version Windows.

How To Create And Insert Calendar In Excel?

#1 – Inserting Calendar Based On Templates Available In Excel

To insert Calendar in spreadsheets that can calculate everything, Microsoft Excel includes graphic options with drawing tools, clipart, charts, tables, etc. The detailed guidelines for creating a custom Excel monthly calendar are here.

To insert a Calendar based on Templates available in Excel, follow the below steps;

  • Step 1: First, go to the File tab.
  • Step 2: Next, select the New option from the list.
  • Step 3: Then, enter the Calendar in the search box.
  • Step 4: Now, select the format of the Calendar amongst the displayed format.
Calendar in Excel - Inserting Based on Available Templates - Step 4

#2 – Inserting Seasonal Photo Calendar In Excel

To insert the Seasonal Photo Calendar in Excel, follow the below steps;

  • Step 1: To begin with, go to the File tab.
  • Step 2: Next, select the New option from the list.
  • Step 3: Then, enter the Calendar in the search box.
  • Step 4: Now, select the format of the Calendar amongst the displayed format.
Calendar in Excel - Inserting Seasonal Calendar - Step 4
  • Step 5: Now, select the Seasonal Photo Calendar, and the detailed box opens.
  • Step 6: Next, select the Create button, as shown in the below image.
Inserting Seasonal Calendar - Step 6
  • Step 7: Finally, the Calendar is formed on the Excel sheet, as shown in the below image.
Inserting Seasonal Calendar - Step 7
  • Step 8: Now, the Calendar Settings box appears on the screen. Meanwhile, we can make changes in the Year cell, which will update automatically.
Inserting Seasonal Calendar - Step 8

#3 – Using Date Picker Control

To use Date Picker Control for Excel Calendar, follow the below steps;

  • Step 1: To start with, select the Insert tab from the Excel ribbon.
  • Step 2: Next, select the Get Add-ins option from the Add-ins group. Now, this browses and adds new functionality as Add-ins to Excel that connect to daily services.
Calendar in Excel - Date Picker Control - Step 2
  • Step 3: Then, the Office Add-ins window pops up.
  • Step 4: Next, select the Mini Calendar and Date Picker Add-in from the list and then, press the Add button.
Date Picker Control - Step 4
  • Step 5: Now, the message box pops up showing, One Moment…. Mini Calendar and Data Picker License terms and Privacy Policies.
  • Step 6: Next, select the Continue button.
Date Picker Control - Step 6
  • Step 7: Now, the Mini Calendar and Date Picker appear on the Worksheet, as shown in the below image.
Date Picker Control - Step 7

Likewise, we can create calendar in excel.

Examples

Example #1

The following example, the image below, depicts the name of employees and will set the Joining date using Add-in Mini Calendar and Data Picker.

In the table,

  • Column A contains the Name
  • Column B contains the Date of Joining
Excel Calendar - Example 1

The steps to add the dates from Calendar are as follows:

  • Step 1: First, select the cell where we want to enter the date.
  • Step 2: Next, click the < > to change the months on the Calendar.
Example 1 - Step 2
  • Step 3: Then, click the left arrow key to change the month to January.
  • Step 4: Now, select the date Gilbert joined the company, and click on it.
  • Step 5: Next, click the selected date.
  • Step 6: Now, the date will appear in the selected cell B2.
Example 1 - Step 6
  • Step 7: Now, the same process is followed in the cells to attain the result, as shown in the below image.
Example 1 - Step 7

Similarly, we can create calendar in Excel.

Example #2 – How To Install Third-Party Add-ins For Excel Calendar?

To Install Third-Party Add-ins for Excel Calendar, follow the below steps;

  • Step 1: To begin with, search in Google for Excel Add-ins and then, download them.
  • Step 2: Next, the Pop-up Calendar tab is added to the Excel Ribbon.
  • Step 3: Now, select the Calendar option from the Pop-up Calendar group.
  • Step 4: Next, select the cell where we want to insert the calendar and then click Calendar.
  • Step 5: Now, enter the date in cell A1; the date reflects in the pop-up calendar.
Excel Calendar - Example 2 - Step 5
  • Step 6: Next, enter the date in cell A2; the date reflects in the pop-up calendar.
Example 2 - Step 6
  • Step 7: Now, we will count the days between the two given dates in cell B2.
  • Step 8: So, the complete formula entered is =A2-A1.
  • Step 9: Now, press the Enter key. The result is derived in cell B2 as 39.
Excel Calendar - Example 2 - Step 9

Likewise, we can create calendar in excel.

Important Things To Note

  • The available Third-party Add-ins Tools in Excel for Date and Time Picker Control are “Ablebits Date Picker,” “Popup Calendar Add-ins,” etc.
  • We need to download and install and use the Third-party Add-ins tools.
  • The Date Picker is used to Add Scheduled dates, changes position, and format the tool.
  • We can delete the Date Picker Calendar by clicking the right arrow at the top of the calendar.

Frequently Asked Questions (FAQs)

1. When to insert Calendar in Excel?

The Calendar in Excel is inserted when we need to plan upcoming activities. The companies use it to reflect the employee’s details, plains of work or tasks, meetings, performance, leaves, etc. The hospitals use it to register the schedule of treatments, appointments, diagnoses, operations, etc. At many workstations, the Calendar feature is used in Excel.
Creating a calendar in Excel can help you complete various tasks, such as organizing your schedule.

2. Ways for inserting Calendar into Excel?

The ways to insert Calendar into Excel are as follows;
First, click the Corner to change the size – The size of the calendar in the spreadsheet can be adjusted. We can drag the four corners of the calendar, pulling the edges outward for a bigger or smaller size.
Connect to the internet to access the templates – To insert Calendar in Excel, it is important to ensure an internet connection so we can access internet templates.
Install third-party add-ins – The Date and Time Picker works for 32-bit Windows products or older editions; consider installing a third-party add-in to create a calendar.
Change page layout for printing capabilities – The layout of the Excel calendar can be changed by clicking the “Layout” menu at the top of the spreadsheet and clicking the “Landscape” page orientation to include the full calendar.
Using VBA code
Using the Pivot table
Using Power Query for Excel
Creating it manually

3. What are the limitations of Excel Calendar?

First, drag and drop feature cannot be used in Excel Calendar.
It can’t create or assign any task.
Creating a reminder feature is very time-consuming and difficult to set.

Download Template

This article must help understand the Excel Calendar examples. You can download the template here to use it instantly.

This has been a guide to Calendar in Excel. Here we learn how to create & insert calendars, templates, add-ins, with examples & downloadable excel template. You can learn more from the following articles –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *