Popup Calendar Addin for Excel

Entering dates in a worksheet confuses most Excel users. Nearly every user has faced a date format problem, which format should be used to enter date? Should we set the month first then day or other way? Which date separator to be used? Is it “/” or “-“? How will the date be parsed when different locale settings are applied? Unfortunately, Excel does not provide an embedded calendar function.

ExcelFort Popup Calendar Add-in can save you all these troubles when it comes to entering dates. Moreover, it provides the following cool features:

Built-in and customized date formats

Select 1st day of week

Last used settings get saved

Control cell selection direction after inserting a date

Get the “ExcelFort Popup Calendar” today just for $ 19.50

The checkout process is quick, easy, and safe.

How to Install the Addin?

Once you have successfully completed the payment process a download link will be sent to your email.

First, download the ZIP file and unzip the add-in file to a location in your computer

In Excel 2007 click the Office Button and choose Excel Options.

In Excel 2010 and above go to the File tab and choose Options

Go to the Add-Ins section of the Excel Options dialog.

Click on the [Go…] button at the bottom of the dialog box, this will open the Add-Ins dialog

3. Click the Browse button to locate and select your AddIn file which you unzipped and saved. Make sure the addin is added and ticked and it appears as shown in the picture on the right.

4. Click on the OK button,

The ExcelFort Popup Calendar Addin is now ready for use. Right-click a cell on an Excel worksheet and click the menu item Insert Date from Calendar will display the calendar. You may also use the shortcut keys CTRL+SHIFT+C to display the calendar.

When the user selects a date, it is automatically entered into the active cell on the worksheet. The add-in will remain so each time you use Excel until you deactivate it by un-checking the box next to its name in the Add-Ins dialog box. If you return to the Add-Ins section of the Excel Options dialog you will see that your Add-In now appears under the heading Active Application Add-Ins.

I would love to hear your comments and suggestions.

Support Is Only a Click Away

I am here to help you with any questions. You can contact me directly if you need any helping with the add-in.

ExcelFort Popup Calendar is very easy to use and it will work for you!

I am trying to download the zip file but not able to find. I clicked on the download and gave my name and email id then followed the link in the email i received again it came back to the same link and asking for name and email id. pls. help.

Just a thought, when I use to change a date in a cell already formatted, I really do not want the format to change also. Also, it does not remember the last format style I used, is there a way to set default format. Works great, much better than I expected!

Great thanks Deb. Just what I need for my excel booking program. Is it possible to have it set so that it defaults to the last setting instead of having to reset it each time? We only use no 4 setting day/dd/mm/yyyy and I would like to fix that setting as a default. We use date pickers a lot.
We were using Jim Cone’s date picker but this one suits our needs better as we need the day and date. I can’t see how to remove it. It does not show in the add in list. Can you advise please.
Thanks for a helpful site

After using this add in for a few weeks I find it is the best one that we have used. Congratulations! One issue though. We paste it into a column that has other entries. One for instance is email addresses. The email address flows into the next column without changing the column width. But when we place the date in the same column (we only use d/dd/mm/yyy ie No 4) it forces the column to widen to catch the longest entry in that column which in our case is usually the email address. We then have to manually drag the column back. I have tried formatting the cells in and beside the entry but it appears to be a formatting setup in the calendar itself. Can that be modified such that when the calendar entry is placed in the cell it will wrap into the next blank cell rather than expanding the column?
Also I understand some changes are being made to it. Could you put a notification on your email mailout please Deb so that we can update?
Thanks
MalR

Regarding the column width, what you are trying get is a more personalised option, rather even if I do not auto fit the column as per format chosen in the calendar, the date won’t flow in to the next cell on the right as the date is basically a number.

Thanks for all your valuable feedback which encouraged me to do some improvements to the Popup Calendar Add-in. in addition to the following improvements, I have also fixed the issue that prevented Excel 2007 users from using the add-in.

What is in the update ?

– Built-in and customized date formats
– Select 1st day of week
– Last used settings get saved
– Control cell selection direction after inserting a date

I tried this. I’m stuck in a loop. I received an email with a link to “download”, but it brings me back to the form for entering email address. Is this real? is there a real software behind this blog? Should be simple to register and download…

Hi,
I’m having the same problem as Jay Kumar had on 22nd March:
I followed the link in the email I received again it came back to the same link and asking for my name and email id again.
When I place the cursor over the download button, I see the text excelfort.com/download-popup-calendar-addin-for-excel/ in the bottom left of the screen, so I assume it is pointing in the right direction.
This looks like a really useful add-in, but it feels like it’s Christmas, when mum and dad forgot to buy the batteries for the new toys. 🙂
Regards
Nick

Sorry to bother you with this Deb. When closing it I get the message; A pop up file named “Popup_calendar-1.0.xlsm” already exists in this location. Do you want to replace it.
If I say No I get the warning that the settings cannot be saved due to an unknown error.
I use it extensively so get numerous warnings each day. Frustrating.
Google explains that; “Application. DisplayAlerts=False” needs to be put into the code.
I am not sure how to get into the code so thought I would check with you first.
Thanks
Mal

Regarding your issue, please delete the addin which you have already installed from the folder. start excel and ignore if you get a message. Go to the Addin Manager and remove from there as well. Now download and install the addin, when you are prompted to copy to the default addin folder, say NO.

It seems the link in the email (once followed) is simply directing us back to the same download page to subscribe again. I can’t seem to get to the download.
Your Popup Calendar looks awesome and I am very much looking forward to using it. Help.
Shane

This is great. I would like to see a setting for date placement into a specific cell location. I have a workbook that is linked to a database and the query depends on a date in one particular cell. Two cells actually. A ‘from’ date and ‘to’ date. I was using 2 of the old MSCALs to help bulletproof the date entry for users looking up data.

Hi,
Just came across this thread and am very interested to find a real working calendar/date picker. Does this work in 64bit Excel 2013?? I have a budget workbook that needs a date picker for dd-mm-yy format.
Thanks
Ron S

Still checking: I’ve been ill so delay in getting back to you.
Can the calendar be called using VBA? If so, are you able to help with this code? I’m pretty much an amateur with very (very) basic VBA skill.