EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Calendar Template
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Calendar Template

By Twinkle SethiTwinkle Sethi

Excel Calendar Template

Calendar Template in Excel (Table of Contents) 

  • Introduction to Excel Calendar Template
  • Creating a Calendar Template in Excel

Introduction to Excel Calendar Template

There are often times when a calendar is needed while working with large worksheets in Excel. Entering dates, date formats, and knowing a particular date of a day all could be problems without an Excel calendar.

We can create our own calendar in Excel using the following ways:

  • Using a pre-made calendar template.
  • Making a custom calendar.
  • Making a Dynamic Excel calendar template with formulas.

Creating a Calendar Template in Excel

Let’s understand how to create a calendar template in excel with some examples.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,547 ratings)
You can download this Calendar Excel Template here – Calendar Excel Template

Example #1 – Using Pre-made Calendar Template

Let’s say we wish to create an Excel calendar using a pre-made calendar template.

Now the following steps can be used to do so:

Step 1: Open Microsoft Excel.

File Menu - calendar template

Step 2: Click on the ‘File’ tab and then select ‘New’.

New Option

Step 3: On doing this, we will see a search field. Type ‘Calendar’ in the search field, and then on search, we will see some templates for the calendar as below.

Calendar Category

So we can see in the above screenshot that there are some inbuilt calendar templates. Each template need not be opened before selection; instead of that, just click on a template, and we can see the template’s preview. This preview gives us a glimpse of the template in terms of formatting, appearance, and layout. Also, these templates can be customized completely, i.e. we can change them as per our requirements.

Step 4: So after selecting the template to be used, click on that template and then click on the ‘Create’ button to the right of the template’s preview. This will open the desired template in Excel. We can select the ‘Any year one-month calendar’ template.

Excel Calendar Template

Step 5: Now, the template can be edited as per our needs. As we can see in the above screenshot, most templates have their own unique features. This ‘Any year one-month calendar’ lets us type in a new year or a week’s starting day to customise the calendar automatically.

Excel Calendar Template

Example #2 – Creating a Custom Calendar

Now let’s say we create our own Excel calendar with a monthly template.

The following steps can be used to do so:

Step 1: Open a new sheet in Microsoft Excel and type the days of the week in the first row of the sheet. This first row will serve as the calendar’s foundation.

days of the week

Step 2: There are seven months in a year that have 31 days, 4 months with 30 days and 1 month with 28 or 29 days. So let us first create a grid of seven columns and five rows by first selecting all the seven columns.

Grid of seven columns

Step 3: Now select five rows under each weekday, and adjust the height of the first column. With all the five rows selected, all rows will adjust to the same height.

week in day

Step 4: Now, day numbers can be aligned to the upper right of each cell (or box) of this 7*5 grid. Select all the cells and then right-click on any one cell and click on ‘Format Cells’.

Excel Calendar Template

Step 5: Now, under the ‘Text Alignment’ section, set ‘Horizontal’ to ‘Right (Indent)’ and set ‘Vertical’ to ‘Top’:

Alignment 1

Step 6: Next step is to number the days. We can know which day is the first day of the month and then align numbers accordingly. For instance, for 2019, October started from Tuesday, so we start numbering from Tuesday as follows:

Excel Calendar Template

So this sheet can be copied in the following way:

Step 7: First, we can rename this sheet as ‘October’ or whichever month we have created. Then right-click on the sheet name or tab and select ‘Move or Copy.

Move or copy 1

Step 8: A pop-up window will appear. Select ‘Move to End’ under ‘Before Sheet’ and checkmark ‘Create a copy and then click on ‘OK’.

Move or copy 2

This will create a new sheet. Now we can rename this and number all the days as per the next month. We can repeat this for all the months depending on the number of days in each month. We can add a row label or heading in each tab and then name the months.

So after finishing numbering of all the months, we will have a calendar in Excel for the entire year, i.e. will have a calendar template as follows:

calendar template in excel 4

Now, this was a custom monthly calendar. This way, a custom weekly and a custom yearly calendar template can also be created.

Example #3 – Dynamic Excel Calendar Template with Formulas

Now let’s say we create a dynamic calendar for a monthly template.

The following steps can be used to do so:

Step 1: Click on the ‘Insert’ and ‘Spin’ button under the ‘Developer’ tab and insert this to the right of the template. (If the ‘Developer’ tab is not activated, then we can do that by clicking on ‘Customize Ribbon’ and ‘Developer’ under File options).

Developer Tab - Excel

Step 2: Now select ‘Format Control’ after right-clicking on the ‘Spin’ button.

Format Control excel

Step 3: A pop-up window will appear. Select the following in the window and click on ‘OK’.

Format Control -1

Step 4: Now, since a specific month calendar is being created, so we create 12 different sheets for 12 months. So we create 12 different Name Managers for this and name the cell H2 as ‘Year’ by right-clicking on the cell and selecting ‘Define Name’:

Define name 1

The heading can be changed by applying the formula.

Changing the Heading

Step 5: Now, we create one more Name manager for this month as follows.

Define name-calendar

Step 6: Now, in the first-day column, apply the following formula:

=IF( AND( YEAR( NovemberOffset + 1)=Year, MONTH(NovemberOffset + 1) =11), NovemberOffset + 1, “”)

Appyling Formula

Step 7: Then copy and paste the formula to the remaining cells, but change 1 to 2, 3 and so on. Similarly, everything is to be increased by 1.

November 1

The same logic can be applied to all the sheets of different months by changing the month from 11 to 12 (November to December) and so on. After completion of all the sheets, the template can be controlled by the first sheet only. We can change the year using the spin button, and then in all the months’ sheets, the selected year dates will show up.

Things to Remember About Excel Calendar Template

The type of calendar one wishes to create depends on how they plan and organize their days.

Some of the Excel calendar templates that can be downloaded for free in some Excel versions are:

  • Academic Calendar
  • Any year one-month Calendar
  • Birthday Calendar
  • Social Media Content Calendar

Recommended Articles

This is a guide to Excel Calendar Template. Here we discuss how to create a calendar template in excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles to learn more –

  1. Insert Calendar In Excel
  2. Excel Calendar
  3. Business Plan Template in Excel
  4. Timecard Template in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Calendar Excel Template

EDUCBA

Download Calendar Excel Template

EDUCBA

डाउनलोड Calendar Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more