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 2. Total comments: 109

  1. Thank you very much it's useful I got

  2. Hello
    Great post.
    I see that I have 64-bit Office installed, so I`M not seeing these controls.
    However, why is this not available for 64-bit excel? Does that make any logical sense?
    Also, if I install 32-bit excel, and get access to the data picker.

    What if I make a form with a date-picker, and one of the people using the form has 64 bit excel installed. Will it still work for them?

    Thanks in advance.

  3. Hello,
    There is any way to do it with 64bit?
    Thank you,

  4. how i to do without mscomct2.ocx?

  5. The date picker works fine but in a different way, the date picker is the one changing once you change the linked cell to it. Did I miss anything because it works the other way around. Please help.

    1. Hi Nats,

      In fact, it works both ways. When you select a date using the date picker, the linked cell changes; and vice versa - changing the linked cell changes the date picker.

  6. This really helped me but I have a slight problem. When I scroll up and down there is a bit of delay in display or should say unsmooth. Its almost seems like the form a dislocating but then jump back to there positions. Does anyone have any idea experience this or Im alone. What's the fix? Thanks

  7. I have been trying for a few days to figure out how to create my own printable daily calendar/planner. This article is a great help with the tools however I am still trying to figure out the best way to populate each day automatically. I have created a 1 day 2 page layout. I want to have the day of the week, and date-no year appear at the top of the first page in separate cells. Then have the next 30/31 worksheets pre-populate with the next day and date. I know there must be an easy way to do it but it alludes me. Please advise. Thanks!

  8. it does not let me run to execute, what comes?
    help me please :'(

  9. I have been searching for calendar control and finally i get solution from here, thank you so much for your detailed instruction. You are amazing!

  10. Great Solution.
    Been trying for weeks to sort this out. Thank you..

  11. Is it posible to add a drop down date picker on the 16.20 version for Mac?

  12. Need to create a formula for a garnishment of a 15% for Student Loan as follows: Gross pay less taxes (SS, SDI, SIT) = net disposal x 15% to obtain garnishment.

  13. I have a rule to fill cell B21 orange when the date in cell E22 is within 30 days of today: =E22<TODAY()+30 and this works perfect. however, now that I have figured out how to input this calendar, it does not work

    I have linked my calendar to cell E22 and the date populates, but the formula in cell B21 does not seem to register that a date has been put into cell E22.

    If I manually type the date in it does work though...

    PLEASE HELP!

  14. I appreciate your kind informative education that you provide with us on this platform, that we might be able to solve random problems by ourselves.
    Thumbs up guys, keep up doing the good work!

  15. Will this work in VBA Userforms?

  16. Hi..
    I'm using organization laptop and its not possible for me to install any 3rd party tool. moreover there is not any date and time picker in developer tab as its missing from there or i say its not installed. Is there any other way in which i can make any hidden calendar in different sheet and get drop down in main sheet.

  17. How do I change the displayed format of the date?

    It shows 14/08/2018, and I'd like 14 AUG as the format (ideally capitalised but not essential). So it looks like I should go into Design Properties, and set "Custom Format" to "dd mmm" and set Format to "3-dtpCustom" which I assume triggers it to apply the Custom Format box above?

    However that results in 14 00 as the display. Indeed, any variation of mmm in the custom format returns a 00 regardless of the month selected in the drop down.
    What am I doing wrong?

    1. I guess by now you may have figured out the problem, but for persons with similar issues, for the custom date format, you have to use capitalized m for month eg. yyyy-MMM-dd

  18. Calendar cell keeps jumping up in left upper corner of the sheet. If I delete and insert again it helps SOMETIMES, but closing and reopen the sheet makes the problem reoccur

  19. Hello,

    I have an online excel sheet i am working on and it has a lot of date columns, hence, i need to add a date picker to the excel online sheet so all other users can adhere strictly to my date format. How can you assist with this?

    Thanks in advance

  20. Hello...
    The choosing of dates, past present and future are great! Is there a function I'm missing to select time? I have a need to enter time in a particular cell. I Have a column for due dates, next to that I have a column for a specific time... the time column can be a function from the date column but with a time format... However, the time is always now.
    Thanks in advance!

  21. 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

  22. 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..

  23. 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........???

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

  25. 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?

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

  27. 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.

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

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

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

  31. 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

  32. 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

  33. wow

  34. 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!

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

  36. 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?

  37. Is there a 64-bit option?

  38. 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.

  39. 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

  40. 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

  41. 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!

  42. "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....

  43. 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?

  44. 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?

  45. 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

  46. 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

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

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

  49. Hi

    Thank you Very much its working !!

    Jubin Thoppil

  50. 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.

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 :)