Insert dates in cells from a handy date picker with easy date formatting

(Note: the video may not reflect the latest upgrades. Please use the guide below.)

Every time you start entering a date in a cell, you wonder… Should you type MM/DD/YYYY or use some other order? Should you use ‘/’ or maybe ‘-’ separator? Will the date format display exactly as you want? That's when an Excel date picker, or a drop down calendar, comes in handy. Indispensable even, when you manage personal or business to-do lists, appointments or timetables, project trackers or financial reports in Excel spreadsheets.

The Popup Calendar is a comprehensive and reliable date picker trusted by 30 000+ Excel users:

  • Intuitive in use: click on a cell – pick a date
  • Drops down near a cell, displays week numbers, days of the week and the current date
  • Populates columns, rows or any ranges with date values in one click
  • Numerous default date format options, preset and custom
  • Works both in 64 bit and 32 bit Excel

Before you begin, add Popup Calendar to Excel

Popup Calendar is one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Get started with XLTools ribbon
– free trial gives you 14 days of full access to all features.

How to insert or change a date in a cell using the Popup Calendar

  1. Select a cell.
  2. In the Date/Time group, click the Insert Date button The date picker will drop down next to the cell.
    Or:right-click and choose Insert Date.
    Or:use a shortcut – press Ctrl + ; (semi-colon).
  3. Pick a date you need from the calendar Done.
    Note:is it what you wanted? Learn how to change the default date format.
  4. To change a date value, click on the Calendar icon to the right of the cell Change date.

The Popup Calendar remembers the last used date, so it is easier to insert a date the next time.

Note:after you enter a date, the cell is automatically assigned Number/Date format. If you delete the date value later, the cell will still keep its Date format, and the Popup Calendar icon will remain available for this blank cell. To remove the icon, change the cell's format to General.
Insert a date into a cell from the Popup Calendar

How to insert the current date in a cell from the date picker

  1. Select a cell where you want to insert the current date.
  2. In the Date/Time group, click the Insert Time button The Calendar will drop down.
    Or:right-click and choose Insert date.
    Or:use a shortcut – press Ctrl + ; (semi-colon).
  3. Click Today on the bottom of the Calendar Done.

How to populate an entire column, row or non-adjacent cells range with dates

You can use the Popup Calendar to fill in dates throughout an entire range (limitation up to 4000 cells). Populate table columns, rows, merged cells, non-adjacent cells or any custom range just the same, as a single cell:

  1. Select a range.
  2. In the Date/Time group, click the Insert Time button The Calendar will drop down.
    Or:right-click and choose Insert Date.
    Or:use a shortcut – press Ctrl + ; (semi-colon).
  3. Select a date Done. The whole range is populated with the selected date value.
  4. To change a date in a specific cell, click on the Calendar icon to the right of the cell Change the date.
Note:after you enter a date, the cells are automatically assigned Number/Date format. If you delete the date values later, the cells will still keep their Date format, and the Popup Calendar icon will remain available for these blank cells. To remove the icon, change the cells' format to General.
Populate a range with dates from the Popup Calendar

How to insert a From-To date period in cells

When you need to specify a date period, you can pick the From date and the To date from the calendar and insert them into cells instantly. It works similar to how you would select dates when booking a flight or a hotel.

For example, indicate vacation dates from Monday to Friday in your Excel absence tool, or enter lease dates for rental units, or specify a work day for hired freelancers, etc.

  1. Select two cells (adjacent or not).
  2. Click the Popup Calendar button on the XLTools ribbon.
  3. Pick the Start Date from the calendar Hold the left mouse button and move through the dates Release the button on the End Date Done.

These cells will have a date format and can be used in further calculations.

Use a Popup Calendar in Excel to insert a date period into two cells

You can also insert a date period into a single cell.

  1. Select one cell.
  2. Click the Popup Calendar button on the XLTools ribbon.
  3. Pick the Start Date from the calendar Hold the left mouse button and move through the dates Release the button on the End Date Done.

Note that the cell will have text format, and you won’t be able to apply formulas to it.

Use a Popup Calendar in Excel to insert a date period into one cell

How to populate a range with consecutive dates

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

  1. XLTools tab Settings button Date/Time tab Check the box Auto-increment dates when I use date picker for a range of cells OK.
  2. Select a range.
  3. In the Date/Time group, click the Insert Date button The date picker will appear.
    Or:right-click and choose Insert Date.
    Or:use a shortcut – press Ctrl + ; (semi-colon).
  4. Pick the starting date to fill the range Done, the whole range is automatically filled with consecutive date values with 1 day increments.
Insert consecutive dates from the Popup Calendar

How to insert both date and time into a cell

  1. Select a cell.
  2. In the Date/Time group, click the Date & Time button The Popup Calendar with Clock will appear next to the cell.
    Or:right-click and Insert Date & Time.
    Or:use a shortcut – press Ctrl + ; (semi-colon), then release the keys and press Ctrl + Shift + ; (semi-colon).
  3. Set the time by using a scroll wheel or the Up/Down arrows Choose a date from the Popup Calendar Done.
    Note:the time format: is it what you wanted? You can change the default format of the Popup Calendar and Clock.
  4. To change an entry, click on the icon to the right of the cell Change time and date.
Note:after you enter date and time, the cell is automatically assigned Number/Date format. If you delete the value later, the cell will still keep its Date format, and the Popup Calendar with Clock icon will remain available for this blank cell. To remove the icon, change the cell's format to General.
Insert both date and time into a cell from the date picker

How to insert only time (without date) into a cell

Use the Popup Clock time picker to set and insert time into cells and ranges:
  1. Select a cell or a range.
  2. In the Date/Time group, click the Insert Time button The Popup Clock will appear next to the cell.
    Or:right-click and Insert Time.
    Or:use a shortcut – press Ctrl + Shift + ; (semi-colon).
  3. Set the time by using a scroll wheel or the Up/Down arrows Press Enter Done.
Insert time only into a cell from the Popup Clock

How to change the default date format of the Popup Calendar

You can change the default date format of the Popup Calendar:

  1. Click Settings on XLTools ribbon Date/Time tab.
  2. Check the box Use the Date and Time format below as default.
    Note:if you uncheck this box, the Popup Calendar will use the format specified in your system settings.
  3. Select your preferred format, e.g. the format customary in your country or language.
    Or:define and set your custom format.
  4. Click OK Done.
Set custom date format for the Popup Calendar

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, change the cells' format:

  1. Select cells Right-click and choose Format cells.
  2. Open Number tab Date format Select the required date format.

Initially, the Popup Calendar employs your system settings for default date and time 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 your computer.

How to change a shortcut for the Popup Calendar

For your convenience, the default shortcut for the Popup Calendar is Ctrl + ; (semi-colon) – the same combination used in Excel to insert the current date. You can change the Popup Calendar shortcut at any time:
XLTools tab Settings button Shortcuts tab Set a different shortcut OK.
Set shortcut keys for the Popup Calendar in Excel

Customize Popup Calendar settings

You can set up the way the Popup Calendar is displayed. You can choose to:

  • Display one or two months at the same time
  • Display week numbers or not
  • Specify the first day of the week: Sunday, Monday, or any other
  • Display Day Count panel or not

The Day Count panel shows the quick day count relative to the current date.

Hover over any date in the Popup Calendar — and see how many days it was before today or how many days after today. Or select a date period — and see the number of selected dates.

Add quick day count panel in Excel calendar

You can also choose to display two months at the same time, show week numbers, and set the first day of the week.

Define how to display Popup Calendar in Excel

Specify these customization options as necessary in the settings:

  1. Click Settings on the XLTools ribbon Date/Time tab.
  2. Check the relevant boxes.
  3. Click OK Done.
Specify Popup Calendar Settings

How to add/remove the Popup Calendar icon

The Calendar icon appears to the right of a selected Excel cell, when the cell has Date format. Clicking the icon opens the date picker.

  • To disable the Calendar icon:

    1. Click Settings on XLTools ribbon Date/Time tab.
    2. Uncheck the box Display the Popup Calendar and Clock icons OK.
    3. Done! The icons will not display, but the Calendar and Clock will still be availalbe for use. You can bring the icons back at any time.
Hide or display Calendar drop-down icons in Excel
  • To make the Calendar icon readily available near a blank cell, column, row or custom range:

    1. Select a blank cell or a range.
    2. Home tab Number group Date OK. This will assign time format to the cells.
      Or:use the Popup Calendar to insert any date Press Delete. This will remove the actual date values and yet assign date format to the selected cells.
    3. Done! Now if you select any cell in this range, the Calendar icon will appear near that cell.
  • To remove the Calendar icon from empty cells:

    If a cell is empty, but it still has an icon beside it, it means that the cell still has date or time format assigned. To remove the icon from blank cells, change their format back to General:

    1. Select a blank cell or a range.
    2. Home tab Number group Date OK. This will assign time format to the cells.
      Or:use the Popup Calendar to insert any date Press Delete. This will remove the actual date values and yet assign date format to the selected cells.
    3. Done! Now if you select any cell in this range, the Calendar icon will appear near that cell.
  1. Click Settings on XLTools ribbon Date/Time tab.
  2. Check/uncheck the relevant boxes:
    • Add “Insert Date” to the context menu
    • Add “Insert Time” to the context menu
    • Add “Insert Date & Time” to the context menu
  3. Click OK Done.
Add or remove Popup Calendar and Clock from Excel right-click menu

How to embed a date picker into a spreadsheet

Try the Embedded Calendar feature. You can embed the Calendar into a workbook, and it will be available to other users of the workbook.
Any questions or suggestions?
Ted ArcherI have embedded the popup calendar into a workbook. I then formatted cell F9 as a date field. The popup calendar icon does not appear next to the cell F9, but instead appears next to cell T3. How do I get the icon to appear next to cell F9?
December 9, 2022 at 15:51
GaryHow do I restrict the popup calendar to only one cell in my workbook?
May 23, 2022 at 05:37
NarayanHey, I want to use date picker calendar to insert dates in a particular column. The calendar should not show dates after current date on any day. Start date of the calendar can be from any year say 2015.How can I achieve this feature in Excel 2010
July 11, 2020 at 15:57
Mpho KhumaloIt works wonders, I just have to figure out how the will update my ODBC table. Thanks
May 22, 2015 at 06:53
StevePeter, 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.
March 9, 2015 at 16:00
KirstenHello 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
March 4, 2015 at 00:22
Rainaso, 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!
January 28, 2015 at 20:04
David CaraballoExcellente. Merci beaucoup.
December 12, 2014 at 23:51
VigneshIf 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?
December 3, 2014 at 11:25
Peter LiapinHi 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".
July 30, 2014 at 09:06
TNNI 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
July 29, 2014 at 20:36
dany claeysMy 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.
July 28, 2014 at 05:53
MichelleHello 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
June 9, 2014 at 18:47
Arturo DominguezI have the 14 days version to trial before purchase it. What happen if I change my computer an excel application? Regards
March 10, 2020 at 11:51
Maria BalobanovaHi Arturo, you can transfer your license to another computer and use XLTools there, as long as your new system (Windows and Excel) meets the system requirements.
March 11, 2020 at 09:06
Hilalcan i have offline installer?
October 20, 2019 at 08:49
Maria BalobanovaHi Hilal, sure. I have sent you an email with details.
October 22, 2019 at 09:53
Debra D SandersNo Add need.
October 5, 2019 at 01:56
Maria BalobanovaHi Debra, sorry, this is not clear. Do you have a problem with the Popup Calendar?
October 7, 2019 at 09:08
Steve Pauley I paid for a lifetime liscense key for this addion.  However, I have not received any information in my email.  Will I receive it?
May 20, 2019 at 14:25
Maria BalobanovaHi Steve, thank you for purchasing the license! License keys are sent automatically (please check you spam folder). Just in case, I have sent you an email with your license details.
May 22, 2019 at 08:48
Berna Hi team, My antivirus blocked the installation it seems this is a malware. pls clarifi.  
May 9, 2019 at 04:25
Maria BalobanovaHi Berna, Thank you for reporting this! Which antivirus software do you have? We have tested vigorously for most common software. We guarantee that our XLTools add-ins are malware free.
May 15, 2019 at 10:06
SulaimanHi, I am receiving an error message saying " Sorry, The Popup Calendar does not support Excel Workbooks with right-to-left display setting" My excel display is bi-directional
September 27, 2018 at 11:43
Maria BalobanovaHi Sulaiman, Indeed, the Popup Calendar does support right-to-left worksheet display. But it works for left-to-right display settings: File > Options > Advanced > Display section > Default direction: Left-to-right.
September 27, 2018 at 17:26
AlexIs the calendar shareable, I have a spreadsheet that I share with a group. Would they be able to use the pop up calendar?
October 12, 2016 at 14:43
Maria BalobanovaHi 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.
October 13, 2016 at 10:49
Baldevbhai GhodasaraI want to add popup calender in excel-2007 version. What can i do ?
May 26, 2016 at 17:47
Maria BalobanovaThank 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!
May 30, 2016 at 11:45
Suzanne PalmerI'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!
December 17, 2015 at 22:29
Maria BalobanovaThank 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.
December 18, 2015 at 15:58
JerryHi, 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.
October 23, 2015 at 21:22
Maria BalobanovaHello 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!
October 26, 2015 at 11:32
JoeHello! 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
September 29, 2015 at 21:42
Maria BalobanovaHello 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!
September 30, 2015 at 10:10
JimI 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 ...............
September 20, 2015 at 03:56
Maria BalobanovaHello 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!
September 21, 2015 at 11:09
HermienHi, 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
September 15, 2015 at 09:22
Maria BalobanovaHello 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!
September 15, 2015 at 10:17
Graham DaleHi, 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
September 10, 2015 at 11:43
Maria BalobanovaHi 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.
September 10, 2015 at 13:51
Jane RoweThank 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
August 29, 2015 at 10:51
Maria BalobanovaJane, 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!
August 31, 2015 at 10:26
Manish BarariaHi, 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
July 24, 2015 at 09:18
Maria BalobanovaHello 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!
July 24, 2015 at 15:15
Pierre Du PlooyHello 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
May 13, 2015 at 06:15
Peter LiapinHello 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.
May 21, 2015 at 21:18
Roger McKeeHello 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.
May 13, 2015 at 14:47
Peter LiapinHello 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.
May 21, 2015 at 21:16
MalHi 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
April 28, 2015 at 01:21
Peter LiapinHello 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.
May 12, 2015 at 17:23
Andreas WinklerHello! 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
May 8, 2015 at 17:36
Peter LiapinHello 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.
May 12, 2015 at 17:18
Cheryl DayHi 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
April 23, 2015 at 15:23
Peter LiapinPlease, follow the installation guide.
April 28, 2015 at 08:17
Mor SagmonHi. How can I get the calendar popup to work with Excel 2007? Thanks! Mor
April 17, 2015 at 08:03
Peter LiapinHi Mor, You just need to install it. Please, follow the instructions here. There is nothing special for Excel 2007.
April 28, 2015 at 08:16
rupiThanks! 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
March 15, 2015 at 23:07
Peter LiapinHello 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.
March 20, 2015 at 14:31
ChrisHello, 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?
February 26, 2015 at 19:41
Peter LiapinHello 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.
February 27, 2015 at 20:24
MarkHi 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
February 10, 2015 at 20:22
Peter LiapinHello 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.
February 11, 2015 at 16:28
ronenhi 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?
February 10, 2015 at 09:06
Peter LiapinCould 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).
February 11, 2015 at 16:06
JohnI 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?
January 29, 2015 at 21:53
Peter LiapinHi John, Yes, you can turn it off completely in settings. There is checkbox where you can completely disable popup calendar.
January 30, 2015 at 15:31
ArnaudHi, 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.
January 27, 2015 at 14:27
Peter LiapinHello 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.
January 28, 2015 at 10:56
ArnaudThanks Peter, Looking forward for the next release... Cheers, Arnaud.
January 30, 2015 at 12:57
Dave GonynorWill the add-in work for spreadsheets uploaded to Microsoft OneDrive and shared?
November 28, 2014 at 17:18
Peter LiapinHello 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.
November 28, 2014 at 18:28
HeikeHello 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
November 14, 2014 at 22:38
Peter LiapinHello 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).
November 15, 2014 at 12:31
manoThank you very much for the make of XLTools calendar kind regard mano
August 28, 2014 at 22:07
Peter LiapinHi Mano, Thank you for your feedback. I really appreciate it.
November 14, 2014 at 19:55
Richard DawsonThanks 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
October 22, 2014 at 10:17
Peter LiapinHi Richard, Unfortunately it is not possible to use our Popup Calendar on UserForm.
November 14, 2014 at 19:54
AnaHello, Thanks for XLTools! Is it possible to adjust pop up calendar to show the day first (in this format day/month/year)? Regards, Ana
November 1, 2014 at 18:56
Peter LiapinHi Anna, Yes, it will be possible in the next version of XLTools which we plan to release really soon. Keep in touch!
November 14, 2014 at 19:53
JonsPeter, 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?
August 13, 2014 at 19:06
Peter LiapinHi Jons, Nichola, Thank you for your question. Unfortunately it is not yet possible, but we plan to add this feature in the future.
November 14, 2014 at 19:48
John ChowHi 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!
December 4, 2014 at 14:13
Rob KeppelI 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.
January 11, 2015 at 23:29
Andrew de WetI 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...
January 17, 2015 at 23:11
NicholaHi Peter, I would appreciate the answer to this question also as this was the first thing that came into my mind! Thanks :-)
November 14, 2014 at 19:09
dany claeysI 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?
July 28, 2014 at 06:21
Peter LiapinHi 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.
July 30, 2014 at 08:42
HugoHi, 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) ?
July 9, 2014 at 15:06
Peter LiapinHi 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!
July 9, 2014 at 15:19
HugoThanks 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!
July 9, 2014 at 17:38
MichelleHi, 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
June 9, 2014 at 05:30
Peter LiapinHi 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
June 9, 2014 at 08:35
Rod RitchieHi, 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. :)
May 3, 2014 at 02:41
Peter LiapinHi 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!
May 5, 2014 at 11:47
JadaThank 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?
April 21, 2014 at 02:10
Peter LiapinHi 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.
April 28, 2014 at 20:10
JadaHi 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. :)
May 21, 2014 at 17:30
Peter LiapinHi 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!
May 26, 2014 at 10:48
How can we help?