Comments on: How to create calendar in Excel (drop-down and printable)

The tutorial shows how to insert a drop-down calendar in Excel, and how to quickly create a printable calendar based on a template. Continue reading →

Comments page 3. Total comments: 109

  1. Is there any way of accessing a date picker in Excel within Office 365 on a 64 bit machine?

    If not is there any plan to include this functionality in the future?
    Thanks

  2. The date picker is working fine, but when i fix it in a cell after doing all the essential formatting, save it and try reopening the same file the date picker is at the top left corner. I face this issue each and every time I re-open the file. Request you to kindly help me in solving this issue..

  3. Hi,
    this was very helpful to create "How to create calendar in Excel (drop-down and printable)"...
    However when I tried to create a calendar in the same sheet but another cell it does not help..........
    any suggestions please........???

  4. Amazing.. Very Helpful.
    Keep the good work on. :)

  5. Hello.. Is there a way for the date box to appear blank until you click on it and then have the calendar pop up instead of having the date auto populate?

  6. Can someone please help me how to populate dates across columns?

  7. I have inserted the Date Picker successfully but need to formula based on the date picked to show the 'due date' in the next column (28 days from date picked, and also to start colouring from green (1-15 days) to orange (16-27 days) & Red (28 days +). Is this possible? Thanks!

    1. Hello,

      If I understand your task correctly, you need to create a rule for conditional formatting.
      You can learn more on how to conditionally format dates and time in Excel in this article.

      Hope this information will be helpful for you.

  8. How do i change the custom (3- dtpCustom) date in the properties drop down.

  9. Great! That works!!! Thank you very much!

  10. Hello. Is there any chance i could copy the date ROM the DatePicker, INTO a cell in the same worksheet? Thank you

  11. Hi I'm looking to create a formula so that when I select a date in the calendar for example 17/10/17 that if would give me the number of days from the 17 to the 31 which I would then want it to calculate say 15/31 of a certain figure is this possible without having a from and to date

  12. Hi,

    I was wondering if you'd guide me how to freeze two different rows in excel (like row no.3 and row no.10)! Is that even possible?

    Thanks

    1. Hi Alireza,

      It's not possible to freeze non-adjacent rows in Excel. Only contiguous columns and rows can be freezed.

      1. Thanks a million

  13. wow

  14. Hi Svetlana
    Thank you very much! I opted for the Date Picker and it works wonderfully. However, your instructions are so thorougfh and clear I could use any of these date options. Thanks!

  15. Muy buen consejo, agradezco mucho su apoyo. Solucionó un gran problema que tenía.

  16. hi,

    thanks for this topic, it really helped me, however, i installed the add-on and when i send the file to my partners, they were not able to use it as they need the add-on, not all of them are having 32 bit, is there any third party tool that can be embedded within the excel file not the excel application?

  17. Is there a 64-bit option?

  18. I have set up a calendar picker and referenced the cell in the properties so that when I select a date in the dropdown calendar, that date immediately appears in a linked cell. However, my calculation will not update until I click on the cell and then on the formula bar. Updates are set to automatic. I am baffled, I have checkd all the settings on the dates format etc.

  19. Hi there,

    I have followed the instructions to a t and unfortunately I continue to get the following error message:

    The Module failed to load and the specified module could not be found. However, when I open the folder I can see the file there and it appears fine.

    Even when I load Excel and click on the Register Custom... the file does not show up in the System32 folder.

    Cheers,

    Sterling

  20. Hi,

    I wish to for the cell with the DatePicker to remain blank as default before the drop-down calendar is selected. How would I go about this please? Any assistance appreciated.

    Excelsius

  21. I have inserted the Date Picker successfully but need to formulate based on the date picked to show the 'due date' in the next column (30 days from date picked). Is this possible? Thanks!

  22. "Easy" does not describe the last three hours of fruitless labour.

    I have an expense spreadsheet that needs a pop-up calendar to choose a date for each line of expenses entered. Third-party is not an option, as it would require installing extra software on multiple off-site laptops.

    The internal Excel process you describe does not allow for applying over a range of cells - each cell has to be configured separately. The 'cell content plus twisty' graphic is just that - a graphic. Clicking on it does nothing. The content can only be changed via a drop-down at the top-left of the sheet, and even then the process is fraught with errors. (I wish I could post a pic of what I'm talking about).

    One would think that allowing for a calendar as one of the Data Validation drop-downs should be a standard no-brainer feature.

    1. I think I might haver encountered the same thing as you, Alan. When I got the calendar graphic in the upper left hand corner of the spreadsheet, I then de-selected Design Mode - that made the upper left graphic disappear, but allowed me to resize and move the graphic of tha calendar near the cell I clicked on to the cell I wanted and it worked. Problem is - I want to copy this calendar drop/select into a range of cells and I cannot seem to do that I have to create a calendar / drop for each individual cell. For what it is worth....

  23. Hello.. Is there a way for the date box to appear blank until you click on it and then have the calendar pop up instead of having the date auto populate?

  24. I have an excel file with 3 sheets. The second sheet is used to keep some reference data for the first sheet.
    In the first sheet I have columns from A to AM and around 4000 rows also with it.
    I want to add BUTTONS to column AM in each row to lock each row after I add something to the cells.
    e.g. I started adding with A1 till AL; now I want to lock these cells in Row A using the BUTTON in AM so that the cells content cannot be edited unless I put password for UNPROTECT SHEET. (please keep in mind that I already have some data validations and conditional formats done with all the cells, and also a macro for blocking CUT-COPY-PASTE to and fro the sheet.) So I would prefer the password for PROTECT my current settings and the one new for the BUTTON option to be different.

    Can you help me?

  25. This is good one, I wanted to know if I can get the time option too in the calendar to mention. At this point of time I know see the date. Please help

  26. I would like to find out if a client attended his/her appointment. So I'd like to add a yes/no button. If the yes button is pushed, I'd like to pick the date the client attended from my drop down calendar and have it populate the Appointment cell (B3) . If no is pushed, I would like the calendar to appear in the followup cell (O3), where a new date is selected but the color is red. This way we will know to also call this patient.

    Thank you for your help.

    Jay

  27. How to get a drop down list in FORM?

  28. Really useful post. I downloaded the third-party software, Excel Date Picker and it suits my need perfectly.

  29. Hi

    Thank you Very much its working !!

    Jubin Thoppil

  30. This is great, but I have one problem. How do I get it to open to today's date by default? Currently it is always opening to January.

  31. please tell me how to add a date search box/bar to a excel document.

  32. I am building a spreadsheet for a client and I'd like to use this date picker. Will the client need to download anything to their office/excel in order to use as well?

  33. I put in the dropdown calendar and linked the cell. As soon as I choose from the calendar, Excel reads the date in the linked cell as a text ("2/13/2017")instead of the date number Excel uses for formulas.

    Can you help?

  34. Hi, I installed the date picker control as suggested and it worked beautifully. The problem was that I sent the worksheet to a fiend who did not have it installed and he could not see the calendars. Just for testing I deleted them in his computer and run some Macros that are in the same worksheet. While they continue to work in my computer the line Sheets("Details").Select comes with an error. "Details is the sheet where the calendars were linked to some cells so I suspect that it has to do with them. What do you think?

  35. This was a great help! I still have a few questions but I'm sure I'll figure it out. Thanks for the help.

  36. Thank you Thank you So much you just made my day!!!

  37. I really like this post. very well explained and demonstrated. But i need some more help in Like if i have two columns (A And B) and both have calendar controls but entire A and B columns i need to enter live dates but only from A and B cell with calendar control..how can i do that.

    pl send me the details on my mail id.

    thanks and regards,

    Kalpana

  38. Hi
    All those explanation was about excel 2010 and later
    do you have any idea about functioning date picker or register it on excel 2007?
    thanks in advance

  39. Microsoft Date and Time Picker Control not appering...plz suggest

    1. Hello Narayan,

      Microsoft Date and Time Picker Control is not available in 64 bit versions of Office. If you are using Office 32-bit, you can download and register the datepicker control using these instructions.

      1. how to add DatePicker instead in a 64-bit version?

      2. Hi, I followed the instructions to add it, and it succeeded. I restarted Excel and still the Microsoft Date and Time Picker Control does not appear under the developer tab > insert > more controls options. What could be causing that?

  40. Thanx a lot for this post. Useful one

  41. Thank you very much.
    I really need this.

  42. Hello

    0 to 60 against 15

    61 to 100 against 20

    101 to 150 against 30
    How to if formula?

    1. Hello Dippak,

      Try the following nested if's:

      =IF(A1>100, 30, IF(A1>60, 20, IF(A1>=0, 15, "")))

      1. So Is it not possible to copy the same date picker to a range of cells. Is there any VBa CODE for the same ?

  43. Hi! I love this blog.
    How can I signup to receive these posts to my inbox???

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)