Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last Updated: Mar 27, 2024
Difficulty: Easy

How to create Calendar in Excel

Leveraging ChatGPT - GenAI as a Microsoft Data Expert
Speaker
Prerita Agarwal
Data Specialist @
23 Jul, 2024 @ 01:30 PM

Introduction

Today, we need to enter the Date and Time in Microsoft Excel frequently for Reservations, appointments etc. Entering the Dates every time becomes tedious and time-consuming. Microsoft Excel Provides a helpful feature where you can add the Date and Time easily and quickly. 

In this article, we will learn how to enable and use Microsoft Date and Time picker.

How to add a Date picker in Microsoft Excel?

To add the Date Picker, we need to enable developer options.

Follow the steps below to enable developer options:

1. Go to Files on the top left corner

2. Now go to options in the bottom left corner

3. Go to customise ribbon

4. Mark the Developer Options and Click Ok

After this, there will be a Developer tab seen in Microsoft Excel.

Now we need to add the mini calendar in Excel.

5. Go to the Developer tab and then click on Add-ins, as shown in the below figure

 

6. Now go to Store and Search for DatePicker in the Search bar

7. Click on the Add, which appears on the right side of the Mini Calendar and Date Picker

After adding the Date Picker, it appears in the sheet as shown below.

Date Picker Calendar

The red Date in the Date Picker represents the current Date.

8. Now, to add the Date using Datepicker, click on the cell where you want to add the Date. Then click on the Date in the DatePicker to add that Date in the current cell.

For example, to add 23-03-2022, see the figure below.

Adding Date in Excel

Similarly, we can add the current time by clicking on the Clock symbol on the Date and Time Picker.

Adding Time in Excel

Changing the Month of the Calendar

You can go to the previous month by clicking on the “<” arrow shown in the above image. Similarly, you can go to the next month by clicking on the “>” arrow.

Deleting the Date Picker

To delete the Date Picker click on the top right corner and then click on Delete.

Click on the Top Right in the Date Picker

Click on the Delete Option.

Get the tech career you deserve, faster!
Connect with our expert counsellors to understand how to hack your way to success
User rating 4.7/5
1:1 doubt support
95% placement record
Akash Pal
Senior Software Engineer
326% Hike After Job Bootcamp
Himanshu Gusain
Programmer Analyst
32 LPA After Job Bootcamp
After Job
Bootcamp

FAQs

1. What is a Date Picker?

Date Picker is a graphical user interface that helps us enter Dates quickly.

2. What are the advantages of Date pickers?

Using Date Picker, we can quickly enter the Dates in Excel. It is simple and easy to use. Date Picker also helps us to control the format of the Date.

3. Is the Date time picker available for all versions of Excel?

The Microsoft Date and Time Picker is not available for 64-bit versions of Excel.

4. Where is the Date and Time Picker available in Excel?

The Date and Time Picker is available in the Developer Tools. We need to enable the Developer Tools and Add the Date and Time Picker in Excel.

5. What is the Usage of the Date Picker?

Date Picker can be used to easily enter Dates in Excel for reservations, appointments etc.

Key Takeaways

We have extensively discussed the Microsoft Date and Time Picker.

We hope that this blog has helped you enhance your knowledge regarding the Microsoft Date and Time Picker, and if you would like to learn more, check out our articles:

Refer to our guided paths on Coding Ninjas Studio to learn more about DSA, Competitive Programming, JavaScript, System Design, etc. 

Enrol in our courses and refer to the mock test and problems available.

Take a look at the interview experiences and interview bundle for placement preparations.

Do upvote our blog to help other ninjas grow. 

Happy Learning!!!

Topics covered
1.
Introduction
2.
How to add a Date picker in Microsoft Excel?
2.1.
Changing the Month of the Calendar
2.2.
Deleting the Date Picker
3.
FAQs
4.
Key Takeaways