By default, the Developer tab is hidden in Excel, but you can force it to appear in no time.
The datepicker control belongs to a family of ActiveX controls, which reside on the Developer tab.
Should they be entered as mm/dd/yy or dd/mm/yy or mm-dd-yyyy? And can I simply type a date like ''? Oh, and what was the date of the first Monday in September this year?Īll of the above problems can easily be solved by inserting a drop down calendar that will let your users fill in dates in a mouse click! This tutorial will teach you an easy way to make such a calendar in Excel, and show how to quickly create a calendar based on a template. When working with large or shared worksheets, maintaining data integrity is the biggest problem, especially when it comes to entering dates. You will also learn a quick way to create a printable calendar based on an Excel calendar template.
The tutorial shows how to insert a drop-down calendar in Excel (date picker) and link it to a specific cell.