Popup calendar

Contents

If you often have to enter dates into worksheet cells, then doing it manually is inconvenient. To enter today’s date, you can use the function TODAY, keyboard shortcut Ctrl +; or a macro, but if you need different dates from the past or future, then drive them in with your hands for a long time. 

Unfortunately, there is no built-in drop-down calendar in the standard arsenal of Excel tools (unlike Word), and even in the latest versions, starting with Excel 2007, Microsoft for some reason removed the mscalc.osx library from the standard distribution package, which allowed you to quickly create a custom calendar form.

Naturally, this “bottleneck” did not go unnoticed by experienced users and Excel MVP experts, who promptly created several interactive macro-based calendars for easy date entry. Here is a selection of good, in my opinion, free options:

Windows Date Picker

Author: Rum de Bruin

Price: is free

Link

  • Installed as an add-in (there are versions for old Excel 200-2003 and for new Excel 2007-2010 and, separately, for Excel 2013. 
  • It is called through the context menu of the cell (right-click on the cell – Date Picker). 
  • Allows you to insert a date in several formats, up to the week number (according to different standards). 
  • Automatically adjusts to the standard of the week (from Monday).
Excel Date Picker

Author: Jim Cone

Price: is free

Link

  • A macro (not an add-on!) with an open source VBA – you can see how everything works and upgrade it “for yourself.” But you need to copy the code to each used file and call it by pressing a button or a keyboard shortcut, i.e. versatility sucks. 
  • Convenient system of scrolling years and months. 
  • week (from Monday) knows. 
  • There are no settings.
Mini Calendar and Date Picker

Author: VERTEX

Price: for free.

Link to Office Apps Store

  • Works only in Excel 2013, added via the Office App Store tab Insert – Apps for Office (Insert – Office Apps Store). 
  • Inserted on the sheet as a permanent graphic object and adds the selected date to any previously selected cell. 
  • Knows how to change the standards of the week, display week numbers, enter not only the date, but also the time. 
  • It is possible to set themes. 
  • There is no button to go to the current day.
Date picker

Author: Sam Radakovitz, Excel Programming Team Leader at Microsoft

Price: is free 

The author’s site is dead, the links do not work, but you can download a copy I once carefully saved here.

  • Installed as an add-on. 
  • Called through the right mouse button on the cell – Pick from calendar or using the convenient pop-up calendar icon to the right of the date cell. 
  • Beautiful design, displaying the number of days before the selected date from the current one. 
  • Uses the USA week standard (displays the week from Sunday). 
  • There are no settings. 

 

PS

Installing add-ons:

  • in Excel 2003 and older – menu Service – Add-ins – Overview (Tools – Add-ins – Browse)
  • in Excel 2007 and newer – File – Options – Add-ins – Go – Browse (File – Options – Add-ins – Go To – Browse)

  • Pop-up calendar from PLEX add-on
  • Automatic date entry when changing a cell

 

Leave a Reply