Popup Calendar for Excel

A solid drop-down datepicker helps insert dates in cells and ranges

Every time you start entering a date in a cell, you wonder… Should you type month/date/year or use another order? Should you use ‘/’ or maybe ‘-’ separator? Will the date format display exactly as you want? Can you insert calendar to Excel?

The Popup Calendar is trusted by 30 000+ users:

  • Intuitive in use – click on the cell, then the date
  • Insert dates in columns, rows, or custom ranges in one click
  • Displays week numbers, current date and time
  • Available from right-click menu and Calendar icon near a cell
  • Navigate month-by-month or drill through to year/decade view

Main features and interface of XLTools Popup Calendar


Add XLTools Popup Calendar to Excel 2016-2007

Works with: Microsoft Excel 2016, 2013, 2010, 2007, and desktop version of Office 365.

Download XLTools Add-in


Learn your way around:


How to insert or change a date in a cell

  1. Select a cell.
  2. Click the ‘Popup Calendar’ button > The Calendar will drop down next to the cell.
    Or: right-click and ‘Select date from calendar’.
    Or: click on the icon near a cell.
  3. Pick a date you need > Done.

Note the date format: is it what you wanted? Learn how to change the default date format.

Select a cell, right-click and pick the date from the Calendar


How to insert the current date in a cell

  1. Select a cell where you want to insert a date.
  2. Click the ‘Popup Calendar’ button > The Calendar will drop down.
    Or: right-click and ‘Select date from calendar’.
  3. Click ‘Today’ on the bottom of the Calendar > Done.

How to insert date and time in a cell

  1. Click ‘Settings’ on the XLTools ribbon > Calendar tab.
  2. Tick the box ‘Add “Date and time selection…” > OK.
  3. Select a cell > Right-click and ‘Select date and time from calendar’ > The Calendar will appear.
  4. Pick time and date you want to insert.

Note the date format: is it what you wanted? If you want, you can change the default date format.

Right-click and pick the date and time from the Calendar


How to insert a date in a merged cell

Use the Popup Calendar to insert dates into merged cells, just the same as into single cells:

  1. Select a merged cell.
  2. Click the ‘Popup Calendar’ button > The Calendar will pop up.
    Or: right-click and ‘Select date from calendar’.
  3. Pick a required date > Done.

How to insert dates in a column, a row or non-adjacent cells range

You can use the Popup Calendar to fill in dates in any range (limitation up to 4000 cells). Fill in a column, a row, merged cells, non-adjacent cells or any custom range:

  1. Select a range, a column or a row.
  2. Click the ‘Popup Calendar’ button > The Calendar will drop down.
    Or: right-click and ‘Select date from calendar’.
  3. Select a required date > Done.

Select a column or cells and pick a date from the popup calendar


How to insert consecutive dates in Excel cells

With the Popup Calendar you can populate a range with consecutive (or sequential) dates fast:

  1. XLTools tab > Settings > Calendar tab > Tick ‘Auto-increment dates when I fill a range of cells’.
  2. Select a range where you want to insert a date.
  3. Click the ‘Popup Calendar’ button > The Calendar will appear.
    Or: right-click and ‘Select date from calendar’.
  4. Pick a starting date to fill the range.

How to change the default date format of the Popup Calendar

  • You can change the date format which the Popup Calendar applies:
  1. Click ‘Settings’ on the XLTools ribbon > Calendar tab.
  2. Tick the box ‘Select Default Date Format’ > Select your preferred format, e.g. the format customary in your country or language.
    Note: Unticking this box returns the default date format.

Open XLTools settings and customize Popup Calendar date format and more


  • You may find that some cells would not comply with the Calendar’s format settings. It means the cells had been assigned a different date format earlier. In this case, do as you normally would in Excel:
  1. Select cells > Right-click > Format cells.
  2. Number tab > Date > Type > Select the required date type.

  • Initially, the Popup Calendar employs your system settings as default date format. You can change your system settings altogether. Note, this will affect all user accounts on your computer:
  1. Control Panel > Clock, Language, and Region > Region.
  2. Formats tab > Set date and time formats, first day of the week.
  3. Location tab > Set your home country location.
  4. Administrative tab > Change system locale > Restart.

How to add/remove the Popup Calendar icon

The Calendar icon appears near a selected Excel cell with date format.

  • Make the Calendar icon readily available near a blank cell, column, row or custom range:
  1. Select a cell, the whole column, row or a custom range.
  2. Right-click > Format cells > Number tab > Date > OK.
  3. Now if you select any cell in this range, the icon will appear near that cell.

  • Disable the Calendar icon entirely:
  1. Click ‘Settings’ on the XLTools ribbon > Calendar tab.
  2. Untick the box ‘Show calendar icon’ > OK.
  3. Calendar icon will not display, but you can use the Popup Calendar as usual.
  4. You can enable the Calendar icon back at any time.

  • Remove the Calendar icon from empty cells:
  1. Select the cell or the range where you want to remove the icon.
    Note: if the cells contain dates, they will change to general values after the operation.
  2. Home tab > Edit group > Clear formats.
    Or: Home tab > Number group > Select ‘General’ from the drop-down menu.
    Or: Right-click > Format cells > Number tab > Select ‘General’ > OK.

How to add/remove the Calendar from the right-click menu

  1. Click ‘Settings’ on the XLTools ribbon > Calendar tab.
  2. Tick/untick the boxes ‘Add “Date selection…” from the right click shortcut menu’ > OK
  3. Now the shortcut to the Calendar is removed from the right-click menu, but the Popup Calendar will remain available on the XLTools tab.

How to embed a calendar into a spreadsheet

The Popup Calendar cannot be embedded into spreadsheets.

But check out our embeddable online add-in XLTools.net Calendar. No installation required – share a workbook with colleagues and they can use the calendar as well. This web-based datepicker is great when you need to send out Excel schedules, templates, time-tables, etc.

 

Any questions or suggestions? Contact us or leave your comment below.

 

84 Responses to Popup Calendar for Excel

  1. Alex says:

    Is the calendar shareable, I have a spreadsheet that I share with a group. Would they be able to use the pop up calendar?

    • Maria Balobanova says:

      Hi Alex,
      The Popup Calendar is not sharable or embeddable. Other users are able to see or use the Popup Calendar only if they have XLTools installed.
      You may be interested in our other datepicker: Calendar Excel Add-in. It is an online add-in, sharable and available in the Office Store.

  2. Baldevbhai Ghodasara says:

    I want to add popup calender in excel-2007 version. What can i do ?

    • Maria Balobanova says:

      Thank you for your interest in XLTools!

      To use the Popup Calendar, please install XLTools. After installation, you will find the XLTools tab on Excel ribbon and you can take the free trial. Enjoy!

  3. Suzanne Palmer says:

    I’m having trouble inserting the calendar into multiple cells and I would like to know if it is possible to insert the calendar into the selected cells without having to pick a specific date? I want the calendar function to be readily available in the cell when I am ready to select the date. Thanks!

    • Maria Balobanova says:

      Thank you for your questions, Suzanne!
      1. Select a range > Click on the Popup Calendar button on XLTools tab > the cells will be filled with the same date you have selected.
      2. You can change the settings (XLTools Settings button, Calendar tab) and opt to increment dates > Select a range > Click on the Popup Calendar button on XLTools tab > the cells will be filled with the consequent dates, starting from the one you have selected (step value =1 day)
      3. If you want the cells to be blank and yet have the Calendar icon available, you have to format the cells in Excel as “Date”. This works for small ranges, as well as for large tables – simple select a few cells, or a whole column and format it as “Date”. The Calendar icon will be available then for any cell in this range.

  4. Jerry says:

    Hi,

    A great popup date utility, keep up the good work!

    After reading all the feedback, lots of the questioners are asking the same question I was about to ask…
    The ability to have your popup code embedded into a new file, so it can be sent to another user and just work.
    Is it possible do you think? How far away are you from achieving it?

    Thanks, Jerry.

    • Maria Balobanova says:

      Hello Jerry,
      Thank you for your question! A Popup Calendar embedded into a spreadsheet, or some sort of distributable template, seems a truly demanded feature. We have researched possible approaches to develop such a template, but came across a few technical bottlenecks. Roughly, instead of extending functionality of our XLTools Popup Calendar, it would have to be a completely different product. So we have decided to put the idea of a distributable calendar on hold.
      But if you think of anything else we can improve with the Popup Calendar or the other features – please let us know. At the moment we focus our development efforts on improving current XLTools functionality and usability. Thanks again!

  5. Joe says:

    Hello!

    I like the Add-in but am having trouble with the ability to not show the calendar options in the right click menu. I have the boxes unchecked in the settings but they still show.

    Any help would be great!

    Thanks!

    Joe

    • Maria Balobanova says:

      Hello Joe, thank you for this report. I have send you an email, could you please reply and send me screenshots? It will help to fix the problem. Thanks!

  6. Jim says:

    I tried down loading app but it says
    The value of the property ‘type’ cannot be parsed. The error is: Could not load file or assembly
    ……………

    • Maria Balobanova says:

      Hello Jim,
      This happens sometimes. Please find the ‘xltools.exe’ file in the ‘My Computer (or This PC)/Downloads’ folder (browsers normally save all downloaded files to this folder).
      Then right-click ‘Run as administrator’. The installation should proceed smoothly!

  7. Hermien says:

    Hi,

    When I use an embedded Excel workbook in Word and I click on it, it does not want to open and give me an error message. It only starts to work again when I unistall XLTools. Is there anyway around this issue?

    Thank you,
    Hermien

    • Maria Balobanova says:

      Hello Hermien,
      You are probably getting the error “Excel is waiting for another application to complete an OLE action”. This problem is rather common for Excel add-ins, and we will try to fix it for XLTools.
      For now, I would recommend you to disable XLTools for the time you are working with embedded workbooks in Word:
      Open Excel > Options > Add-ins on the left side bar > select “COM Add-ins” in the “Manage” drop down menu (in the bottom)> Go > Untick the box with XLTools add-in.
      You can enable XLTools any time, when you are back working in Excel. Thank you for reporting this error, we will work on it!

  8. Graham Dale says:

    Hi,

    We are moving over to 64-bit Office, a lot of our apps use Microsoft’s Datepicker functionality which is no longer supported in 64-bit (why I don’t know). Would you be able to confirm if XLTools is compatible with Office 64?

    Rgds
    Graham

    • Maria Balobanova says:

      Hi Graham,
      Yes, XLTools is compatible with Office 64. Please note – our datepicker (the Popup Calendar) and the other add-ins are developed only for Excel, not the whole Office.

  9. Jane Rowe says:

    Thank you so much for this great tool. I have been “around and around’ trying to figure out how to get MSCOMCT2 to work on my PC to enable Excel to insert a popup calendar but to no avail. I can’t believe you have provided this tool for free! You have restored my faith in a world of corporate greed and you are to be commended.

    As per Manish’s request above, I would also like to share my workbook with colleagues as is to actually a ‘how to’ workbook for entering expense dates at my workplace but my colleagues will not be able to download XLTools due to administrative restrictions. Is there any chance that you may enable this popup calendar on shared workbooks without downloading your Tool yet? This would be fantastic as I am trying to make like easier for my colleagues by providing them with as many shortcuts as possible.

    Once again thank you so very much.

    Regards
    Jane

    • Maria Balobanova says:

      Jane, thank you for your kind words! We really appreciate it.
      We do not yet have a solution for you to share the Popup Calendar with your colleagues. They have to have XLTools installed on their computers. If they cannot install – this is probably due to their local security settings, but I hope your system administrator could help with that. He/she could contact us if any questions!
      Thank you again and enjoy XLTools!

  10. Manish Bararia says:

    Hi,

    I downloaded this for the Calendar popup. However, I have 2 problems
    1) This seems to have been discussed above, and there seems to be no answer to it yet – is that I need to share this workbook, and the other folks will not have the XLTools Add-In.
    2) I need the popup to appear on click of an image or a button. So, say I have a cell where I want the date to be input, I would place a button next to it; on click of this button/hyperlink, I want to open the calendar popup which will put the date in the adjacent cell. How do I do it?

    With all the above questions, I would like to thank the creators of this for a wonderful tool – with or without what I am asking above.

    Regards,
    Manish

    • Maria Balobanova says:

      Hello Manish,
      1) If you share a workbook (within your network or to outside users) – the other users will be able to see/use the Popup Calendar only if they have XLTools installed on their computers.
      2) Unfortunately, you cannot “attach” the Popup Calendar to an image or a button. I assume you also plan to send this form out to the other users/customers – this brings us back to p.1.
      We appreciate your suggestions, we will discuss this for the future XLTools updates. And thank you – happy to hear XLTools is a useful tool!

  11. Mpho Khumalo says:

    It works wonders, I just have to figure out how the will update my ODBC table.

    Thanks

  12. Roger McKee says:

    Hello Peter. A great utility, thank you! I’ve used it in an Excel spreadsheet in which some cells need to be locked so that users can’t interfere with formulas. The cells in which the pop-up calendar is to be used are “unlocked” (Format cells; Protection; untick Locked) before the sheet is protected. Then the Calendar doesn’t insert the date into the cell. Any way around this? Thanks, Roger.

    • Peter Liapin says:

      Hello Roger,

      Please, try to download and install XLTools again. We have released a new version 3.5.3.2 today. The problem you reported should be fixed there.

  13. Pierre Du Plooy says:

    Hello

    I would just like to support Andreas Winkler request for filling cells with the same date. It was the future i properly used the most…. LOL

    Maybe you clever people can solve it by adding a future or tick box in setting to enable this function.

    but i would like to say thank for creation this software it is pretty awesome to use by people like my who dont know to must about pc’s

    Regards

    • Peter Liapin says:

      Hello Pierre,

      Please, try to download and install XLTools again. We have released a new version 3.5.3.2 today where we added a new setting, so you can manage whether you want to insert the same date or use increment.

  14. Andreas Winkler says:

    Hello!

    Since the update I cant fill more cells with the same date now its fills 01/01 02/01 03/01. its there an option ti change it how it was before? thanks so much.

    Andreas

    • Peter Liapin says:

      Hello Andreas,

      Thank you for your question. You are right, due to requests from other users we have changed this logic in version 3.5. We will think about creation of a new setting for this case, so you can use it like you prefer.

  15. Mal says:

    Hi Peter. Can the add in be made to show Day d/m/y? Meaning Monday 12/4/15. I need the day and dates for my work. Especially the year to be two digits ie15 not 4 ie 2015.
    Thank
    Mal

    • Peter Liapin says:

      Hello Mal,

      Yes, since version 3.5 you can select the default format for the calendar in the Settings. Please try to open Settings -> Calendar -> check “Select Default Date Format” and find the format you need in the list.

  16. Cheryl Day says:

    Hi There,

    I have downloaded XL Tools however cant seem to find out how to import this into excel.

    I may be being stupid but how do I do this?

    Thanks,

    Cheryl

  17. Mor Sagmon says:

    Hi.

    How can I get the calendar popup to work with Excel 2007?

    Thanks!
    Mor

  18. rupi says:

    Thanks! this is fantastic!!
    I have been struggling for the past two days to somehow get a pop up calendar for users
    I am quite computer illiterate so please excuse me if the answer to my question is obvious and known to most

    I downloaded your program to my computer and it works like a charm for my excel workbooks

    if I email a work book to be used by someone else – different computer – will the program work on that computer too as long as the same work book is used?

    If so

    will the program work if I use a workbook from this computer as a template and it is used to create different workbooks?

    This is what I really wanted the program for – for others in the team to be able to input the dates and other data

    thanks a ton

    rupi

    • Peter Liapin says:

      Hello rupi,

      Unfortunately, it would not work if you just email your workbook to someone else. Our popup calendar will only work if other people who use the same workbook have XLTools installed too.

  19. Steve says:

    Peter,

    Thanks for the update, however, I must be blind because I do not see the instructions on how to get it working. The pictures at the top of this page after “How to use XLTools Popup calendar in Excel?” do not explain in detail how to do it. I am new to Excel and perhaps I am blind as it is clear. I am using Excel 2010.

  20. Kirsten says:

    Hello Peter,

    I downloaded the XLTools pop-up calendar. I can see the add-in in the COM add-in but I do not know how to access it.

    Thank you for any help you can give.

    Kirsten

  21. Chris says:

    Hello,
    I just installed the tools and it is exactly what I was looking for. I am using this as tracking document in a support desk environment and want to know if i send this to other employees as a template to use do they also have to install the tool kit?

    • Peter Liapin says:

      Hello Chris,

      Yes they will need to install XLTools if they want to use calendar. Unfortunately you can not embed the calendar into your workbook yet.

  22. Mark says:

    Hi Peter

    I see from prior posts that we can not save a file with date picker saved in it so a user can use it with that function. The solution is to install the add in on their clients. I also noted in late 2014 you said it would be coming in a future release.

    This date picker functionality is GREAT. Do you have status on your proposed roll date to be able to save the date picker into a spreadsheet for end users without the add on to be able to use?

    Please let me know.
    Thanks
    Mark

    • Peter Liapin says:

      Hello Mark,

      Thank you for your question. We have done a bit more of research on this topic and it looks like this task it not straightforward. We are still looking for some robust solution to get it done, but I am not sure whether the solution even exist, so I can not say exact date when we have this feature implemented.

      There are some difficulties with x64 and x86 versions of Excel + the only way to embed calendar is to add some VBA to the spreadsheet which means that look & feel of the calendar would be different.

  23. ronen says:

    hi peter
    first of all Thanks!
    when I tray to insert the Calendar in cell D9 for example
    the icon is appear in N9
    there is a way the icon well appear in the same cell of the date?

    • Peter Liapin says:

      Could you please send me a sample worksheet where you have this problem to peter[at]xltools.net? It usually works well, but there may be some specific cases where it fails. May be you have one of these cases which we have not accounted yet (for instance currently you can get similar problem if you switch worksheet to “Page Layout” mode).

  24. John says:

    I would like to return a cell to an inactive date format after using the XLTool calendar, but cannot. Once activated with the Calendar a cell can only be turned off by remaning in a non-date/time format. Is there a way to turn it off completely?

    • Peter Liapin says:

      Hi John,

      Yes, you can turn it off completely in settings. There is checkbox where you can completely disable popup calendar.

  25. Raina says:

    so, i’m computer/program illiterate. I downloaded the calendar XLTools, and hit run and save. but where did it go? I don’t know how to add it to my Add-ins, nor can I find it to add to add-ins. Thanks!

  26. Arnaud says:

    Hi,

    I really like your “Popup Calendar for Excel”! I’ve tried many others from the web but most of them failed to work correctly when I sent my Excel form by email to other users.
    This one keeps working perfect!
    The only drawback I don’t seem to get resolved is the fact that it only supports the ‘Englis US’ date- and time format.
    I’m looking for the Europan date format including the time; i.e. 14 March 2015 1:35PM has to be shown in Excel as: 14-03-2014 13:35.
    Is there any way to set this date & time format accordingly?

    Thanks & regards,
    Arnaud.

    • Peter Liapin says:

      Hello Arnaud,

      Thank you for your question. We will add support for European date formats in the next release. Stay tuned! We’ll let you know when next version is out.

  27. David Caraballo says:

    Excellente. Merci beaucoup.

  28. Vignesh says:

    If i will install XLTools in my system.i wil use calendar fuction.i will send it to my friend. is any possible xltool work in another system without installation?

  29. Dave Gonynor says:

    Will the add-in work for spreadsheets uploaded to Microsoft OneDrive and shared?

    • Peter Liapin says:

      Hello Dave,

      Thanks for your question. Popup Calendar Add-In will only work if a person who opens Excel file would have XLTools Add-In installed on his PC.

  30. Heike says:

    Hello Peter,

    Thank you for building this for us users!! I am trying to use the popup calendar, the date works great but for some reason I can’t adjust the time. What am I doing wrong? I don’t get the bar at the top of the calendar to pick a time. I just see the blue header with the month name and the year on it. I have the cell formatted as m/d/yyyy h:mm.

    Thanks very much for your help!
    Heike

    • Peter Liapin says:

      Hello Heike,

      Thank you for your response!

      Unfortunately, I can not reproduce the problem on my PC. Please, send me a sample workbook where you see that problem (I will write you on email now, so you can reply with attachment).

  31. Ana says:

    Hello,
    Thanks for XLTools!
    Is it possible to adjust pop up calendar to show the day first (in this format day/month/year)?
    Regards,
    Ana

    • Peter Liapin says:

      Hi Anna,

      Yes, it will be possible in the next version of XLTools which we plan to release really soon.

      Keep in touch!

  32. Richard Dawson says:

    Thanks very much for the XLTools calendar – breathtakingly easy to use on a spreadsheet!

    Please could you tell me how to incorporate it into a UserForm?

    Richard

  33. mano says:

    Thank you very much for the make of XLTools calendar
    kind regard
    mano

  34. Jons says:

    Peter,

    If I use your utility in a spreadsheet, and then send the spreadsheet to someone else, will the date picker work for them if they haven’t installed the utility?

    • Nichola says:

      Hi Peter,

      I would appreciate the answer to this question also as this was the first thing that came into my mind!

      Thanks 🙂

    • Peter Liapin says:

      Hi Jons, Nichola,

      Thank you for your question. Unfortunately it is not yet possible, but we plan to add this feature in the future.

      • John Chow says:

        Hi Peter! Wonderful program!!!

        I just have the same request as Jons and Nichola. I have been looking for a date picker like yours but I need for it to be able for users to be able to select the dates when I send the program out and they send back the completed file back to me.

        Thank you again Peter for a wonderful program!

        • Rob Keppel says:

          I too, would use this tool, if the end user did not have to have the XLTools Add-in. Unfortunately, the form I’m creating needs to be sent to my employees, who do not have this Add-In.

          • Andrew de Wet says:

            I would also like to use this add-in if I did not have to install it for every user who is going to access the Excel file. We mostly run 64-bit 2010 and this looks like the only working option…

  35. Peter Liapin says:

    Hi TNN,

    Our popup calendar is working for cells with date format. When you use calendar to set a date for an empty cell it will automatically convert cell’s format to date, so to revert it back you need to go to cell’s format settings and select something like “General” or “Text”.

  36. TNN says:

    I had a cell set up with the calendar function. However, I want to revert it back to a blank cell, but am unable to do so. Every time I input a number into the same cell. It would be convert to a date format. Is there a way to do so? Thank you

  37. dany claeys says:

    I figured out the problem but not a solution. The icon only stays behind the number of rows I freeze at the top. Any way around this?

    • Peter Liapin says:

      Hi Dany,

      Thank you for reporting this issue!

      Yes, you are right. The problem caused by freezed rows/columns. It is a known issue and we will fix it in the next version of XLTools. We are going to release within a next couple weeks. I will let you know when it is release.

  38. dany claeys says:

    My dates start on row 8 because there are headings and text above but the calendar icon is on the first row. When I go down further, the icon stays 8 rows behind. How do I get them to line up next to the row where I want to enter the date? Thx.

  39. Hugo says:

    Hi,

    I use Office 2010 and I have a sheet with a Table on it, unfortunately the “Select date” doesn’t appear when I right click a table. Is there a way to make it happen ? Or, is it possible to create a shortcut with VBA with the same function (alt+q, for exemple) ?

    • Peter Liapin says:

      Hi Hugo,

      It seems like you have XLTools 2.2 installed. In the new version (which was released yeaderday) we have fixed this problem. You need to upgrade to XLTools 3.0 in order to fix this issue.

      In XLTools 3.0 there is also an option to customize shortcuts. By default Ctrl+Shift+D is set to show a Popup Calendar.

      Give it a try! And please, do let me know if you have any other question!

      • Hugo says:

        Thanks for the fast answer, I updated and it worked like a charm.

        I’m definately going to recommend your software here in Brazil.

        Cheers mate!

  40. Michelle says:

    Hello Peter,

    Thanks for the quick response, really appreciated!! It is for paid period that I need to put dates like 1/1/14 – 1/7/14 in one cell. The program is awesome and thanks for sharing!!!

    Have a wonderful day!!!

    Best,

    Michelle

  41. Michelle says:

    Hi,
    Thanks for your program!! Is there any way that I can Post like 1/1/14 – 1/7/14 in one cell ? If yes, how? Please advise. Thanks!!!

    Best
    Michelle

    • Peter Liapin says:

      Hi Michelle,

      Unfortunately, there is no way to enter this value in one cell with our Popup Calendar. But, why do not you want to split this value into two cells? You can even use 3 cells and format this value to look like it is just one single values.

      Please, let us know what you think about above ideas!

      Best Regards,
      Peter Liapin

  42. Rod Ritchie says:

    Hi, and thanks for your program. Is there a way to put a dropdown selector for your calendar in a cell so end users can simply click to enter date in that cell, much like the active x control in Office. I am creating a Business User Form that must be functional for people with various computer knowledge. The form has about 20 or so cells that involve selecting a date to include.
    The Datepicker in Word would be ideal as it has a dropdown arrow to select the date but the default text is “Click here to enter a date” I note that if I use your calendar to insert a date, an icon will appear for users to very simply change the date, however this document will be of a legal nature and may end up as evidence in court proceedings etc, so I cannot have an old/incorrect date in the cell as a default for situations where no entry was required, as it would look like that date had actually been selected.
    Also, is there a way to choose ‘longform’ dates such as Saturday 3 May 2014 rather than 3/5/14.

    Again, thanks for your program and your online support. 🙂

    • Peter Liapin says:

      Hi Rob,

      We plan to add an ability to show date picker icon for the cells with datetime format set. I think we will release this with the upcoming version of XLTools. So, in your form you will need to select empty cells which supposed to be date or datetime and set required date format using standard Excel functionality (i.e. Format Cells -> Select target Date format -> OK).

      You can use ‘longform’ dates if you change the date format for particular cell/cells (see instructions above) – calendar should still work with the new date format.

      I hope you enjoy using XLTools – keep in touch!

  43. Jada says:

    Thank you very much for the use of XLTools calendar. Is there a way to make the calendar selection box not cover the drop list arrow?

    • Peter Lyapin says:

      Hi Jada,

      Unfortunately there is no easy way to do it, but we will try to look at potential solutions. I will let you know if we find how to fix this problem.

      • Jada says:

        Hi

        I found a work around solution for the time being. I merged the calendar cell with the one next to it and now can see the arrow.

        🙂

        • Peter Liapin says:

          Hi Jada,

          I’m glad you found the this workaround and I hope you enjoy using our Popup Calendar add-in!

          Please, let us know if you will have any other questions/proposals!

Leave a Reply

Your email address will not be published. Required fields are marked *