Skip to content

Software clarifies date formatting in MS Excel

Working with date values in Excel is not as easy as it sounds. Should you enter dd/mm/yy or mm/dd/yy? Do you enter slashes or dashes or dots? Pop-up Excel Calendar solves all the headaches by adding a pop-up calendar to your Excel

Working with date values in Excel is not as easy as it sounds. Should you enter dd/mm/yy or mm/dd/yy? Do you enter slashes or dashes or dots? And what was the date of the third Monday in July last year anyway? Pop-up Excel Calendar solves all the headaches by adding a pop-up calendar to your Excel.

Pop-up Excel Calendar can be activated automatically or manually.

The calendar is activated automatically whenever you click or enter a date cell in which you need to enter a date value. Pop-up Excel Calendar can identify a cell as a date cell if the target cell meets one of the following criterions: the cell has a date format; the cell has a date-like value; the cell is underneath a cell with a date value or format in it; the cell is underneath a cell that has some form of the word “date” in it. You can enable or disable the four options respectively.

When Pop-up Excel Calendar identifies a cell as a date cell, an in-cell icon button is shown automatically near the target cell. Click the icon button to open the calendar and pick a date.

If the target cell can not be identified as a date cell, you can open the calendar manually. By default, Pop-up Excel Calendar adds commands for opening the calendar to the cell right-click menu (which is displayed when you right click a cell), the Standard toolbar, and the Pop-up Excel Calendar toolbar. However, you can choose to remove/add any of the command buttons whenever you like.

Pop-up Excel Calendar works even if the Excel workbook / template window is split, frozen, or zoomed. It also provides options to let you control how the calendar works. For example, you can set the First Day of Week option to adjust the calendar layout; set the Default Date Format option to have the calendar set a date format if the target cell is not formatted as date.

If you use date values in Microsoft Excel, why not give Pop-up Excel Calendar a try!

Name: Pop-up Excel Calendar
Category: Microsoft Office Add-in
Home Page: http://www.office-kit.com/excel_calendar/index.htm
Download: http://www.office-kit.com/excel_calendar/pop-up_excel_calendar_setup.exe
File Size: 563 KB.
Trial Type: 30-day fully functional trial version

About this author