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

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

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

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

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

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

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

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

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

  9. Hi

    Thank you Very much its working !!

    Jubin Thoppil

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

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

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

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

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

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

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

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

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

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

  20. Thanx a lot for this post. Useful one

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

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

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