Launched on April 24, 2012, Google Drive allows users to store files in the cloud (on Google's servers), synchronize files across devices, and share files. This way you can share your excel sheet with other users and they can pick a date from calendar to fill the dates.Google Drive is a file storage and synchronization service developed by Google. Now when as you pick the date from calendar it changes the date in your assigned cell. Once you have assigned the date cell, turn off the design mode off again. Under the properties click on LinkedCell and enter the cell number of your date. Now, turn back the design mode on again and click properties under developer tab. If you want to use calendar as a date picker you need to take a few more steps. Now when you click on the little arrow it will bring out the calendar. In the next step, turn off the design mode under developer tab. So select some part on your excel sheet and place it. Now you need to place the calendar somewhere on the screen. In the list, scroll down the Microsoft date and time picker and select it. Once you click the more controls it open a new box with a list of options. The control we are going to use is available by default. More controls allow you to insert a control from the set of controls available on your computer. In the developer tab, click on insert and go to the very bottom, where it says more controls. Now that you have the developer tab, let’s jump right into creating calendar and using it as a date picker. This is where all the magic is going to happen. TADA! Now you have developer tab in your Excel ribbons. You should check the “Developer” option in the right hand box, under main tabs. Now click on “Customize Ribbon” which will bring out some more settings. This opens a new “Excel Options” box with bunch of options to select. The first thing you need to do is click on the file in the top left of your screen and select “Options” at the very bottom of it.

If the developer tab is not already available in your Excel ribbons, you can follow these steps. This guide shows you a trick that might work for you and save you tons of your time.īefore we start, you have to make sure the developer tab is available. A drop down calendar allows your users to fill the dates on a click of mouse. It always confuses the people if they should be mm/dd/yy or dd/mm/yy or mm-dd-yyyy? Or can you type a date like “”? Oh, and what would be the date of the third Friday in October this year?Īdding a drop down calendar in your excel sheet can solve these problems. Especially, entering dates can become a nasty work. It can be a headache to maintain the data integrity when you are working with bigger and shared Excel worksheets.

Have you ever wanted a calendar to show next years date? It’s easy and convenient in most of the cases.

Adding drop down calendar in excel 2013