EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tools Excel Calendar
 

Excel Calendar

Madhuri Thakur
Article byMadhuri Thakur

Updated August 11, 2023

Calendar in Excel

 

 

Calendar in Excel

Excel Calendar is a customized calendar in which we can create our calendar with the help of a template available. The main problem comes when we must decide what the first day of the year will be. For the Year 2020, we all know that the first day started on Wednesday. To decide the day of 1st Jan, use the DATE function to find the first date of the month and then subtract the 1st Weekday Date using the WEEKDAY function along with DATE.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Excel provides a variety of different templates which is already formatted and ready to use.

How to use the Pre-Built Calendar in Excel?

To create a pre-built calendar in Excel, follow the below process:

You can download this Calendar Excel Template here – Calendar Excel Template
  • Go to the File tab.
  • In the left pane bar, click on the New option.
  • It will open several options in the right side window. Refer to the below screenshot.

Calendar in Excel example 1-1

  • In this window, we have to enter what we are looking for in the search box.
  • Type Calendar in the box and press Enter key like the below screenshot.

Calendar in Excel example 1-2

  • It will display various types of calendar options, as shown below.

Calendar in Excel example 1-3

  • It has many options like monthly and yearly calendar formats.
  • Scroll the bar and choose the Photo calendar (Mon) option. Refer to the below screenshot.

Calendar in Excel example 1-4

  • After clicking on this, it will open a dialog box like the below screenshot.
  • Click on Create icon.

Calendar in Excel example 1-5

  • It will open an Excel workbook having a month-wise date calendar. Here month-wise tab is available, as shown in the screenshot below.

Calendar in Excel example 1-6

  • Click on the Jan month tab.
  • It will look like the below screenshot.

Calendar in Excel example 1-7

  • You can select the Year you want to work for by clicking on the Down/Up arrow icon, as shown in the screenshot below.

Calendar in Excel example 1-8

  • Click on the right-side image. It will open a Format tab in the menu bar.

Calendar in Excel example 1-9

  • We can format this calendar by changing pics as per our choice.
  • For this, click on the right-side image. It will open a Format tab in the menu bar. Refer to the below screenshot.

Calendar in Excel example 1-10

  • You can change the address and contact details in the box available on the right side. Refer to the below screenshot.

Calendar in Excel example 1-11

  • By clicking on any date inside the calendar, you can make notes date-wise or month-wise.
  • Like in the below screenshot, we have mentioned some notes date-wise.

Calendar in Excel example 1-12

  • You can customize the calendar using the format tab as per your requirement.

A calendar in Excel is very important in any company, and it uses for different purposes. Here we are taking an example where we will see a way to create a calendar in Excel for a team.

Use Custom Calendar Sheet in Excel

Let’s consider two employee data in a calendar in the Excel sheet. David & Ian are two employees in a team, as shown below:

Calendar in Excel example 2-1

Thus, we are creating a monthly Excel calendar for them. Let’s write the first date of the Jan 19 month in Cell B1. Now, in Cell C1, we will apply the formula =B1+1 for the next date, as shown in the screenshot below.

Calendar in Excel example 2-2

  • Hit the enter key and drag this formula in the next columns for the last day of the month. Here drag till the 31st Jan 19.

Calendar in Excel example 2-3

  • Copy the same dates in Row 2. Refer to the below screenshot.

Calendar in Excel example 2-4

  • Now select the dates from Cell B1 to Cell AF1 and do right-click.
  • It will open a drop-down list of items.
  • Click on Format Cells as shown in the below screenshot.

Calendar in Excel example 2-5

  • Choose the Custom option from the Category window and write “ddd” under the Type field for Weekdays. “ddd” refers to Mon, Tue, etc. Refer to the below screenshot.

Example 2-6

  • It will convert the dates into weekdays in Row 1.
  • Again select the whole dates in Row 2 and write “dd” in the Type field under the Custom option. It will convert the dates into days, as shown in the below screenshot.

Example 2-7

  • Select the columns from B to AF and move the cursor on the line between any two columns, and it will compress the cells as shown in the below screenshot.

Example 2-8

Now we draw a line using the Draw Border option by clicking on the Border option under the Font section, as shown in the below screenshot.

Example 2-9

And our calendar will look like below:

Example 2-10

 

Now our Template is ready. Make a copy of this sheet and give the month name of the sheets, like Jan 2019, Feb 2019, etc. Put the name of this sheet as Template.

For Feb 2019 month, we need to change the date of months like below.

Example 2-12

Using the Hide option, we will then highlight the weekends and hide the unnecessary rows and columns.

Example 2-13

As we can see, the calendar template is ready with us, and now we can use this for scheduling team employee activities date and month-wise.

How to Print a Customized Calendar in Excel?

In the above section, we learned how to create a calendar. We also can take the print of this. Follow below steps for printing a customized calendar:

Step 1 – Go to the Page Layout tab.

Step 2 – Click on the Orientation option under the Page Setup section, as shown in the below screenshot.

Example 3-1

Step 3 – It will open a list of options. Click on Landscape as shown in the below screenshot.

Example 3-2

Step 4 – Choose 1 page under Width and Height boxes in the Scale to Fit, As shown in the screenshot below.

Example 3-3

Now your customized calendar is ready to print on one page.

Things to Remember

  • Using this Excel Calendar, you can easily keep track of daily, weekly, and monthly activities, schedules, etc.
  • You can keep track of your business growth by watching the progress on a fixed-date timeline.
  • You can keep real-time watch and visibility into the business’s status, resources, and performance.

Recommended Articles

This has been a guide to Calendar in Excel. Here we discuss how to use a pre-built calendar in Excel, a Custom calendar, and print the customized calendar along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. Excel Calendar Template
  2. Excel Add Months to Dates
  3. Insert Calendar In Excel
  4. Excel Month Function

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Calendar Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Calendar Excel Template

EDUCBA

डाउनलोड Calendar Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW