Date Picker is a dropdown calendar that helps enter dates in Excel. Just run the tool and click the date that you want to insert into the selected cell. With Date Picker, you can also change a date by adding or subtracting years, months, weeks, and days.
Date Picker is enabled, so now each time you select a cell with a date you'll see the Date Picker icon on the right. Besides, you can open the dropdown calendar by right-clicking a cell and choosing the Select Date from Calendar option.
Right-click any cell and choose the Select Date from Calendar option from the context menu:
Here is the Date Picker pane:
Double-click the needed date or click it and press Enter to insert the date into the selected cell.
Right-click the cell that contains the date you want to use for calculations and choose the Select Date from Calendar option from the context menu. Or click the Date Picker icon next to the selected cell:
To open Date Calculator, click the Date Calculator icon in the upper-right corner of the Date Picker pane or press F4.
You'll see the Date Calculator pane and its elements:
Use the number keys on your keyboard or click the digits on the Date Calculator pane to enter the number of years, months, weeks, or days you want to add or subtract.
Click the plus sign (+) to add or the minus sign (-) to subtract the entered number of years, months, weeks, or days.
Click the equal sign (=) or press Enter on your keyboard, and the result of the calculations will be displayed on the pane:
Click the Put result to cell icon to insert the result into the initially selected cell.
Is there a shortcut where I can change the Date Picker by one or few days. E.g I selected today in my date picker and later realised that it should be yesterday. With a short cut like -ve sign, the date could have reduce by one day. Actually many software has this option. Thanks
Thank you for your question. Unfortunately, there is no shortcut that could be applied to Date Picker. However, there is Date Calculator embedded into the add-in. With its help, you can quickly add or subtract days, weeks, months, or years to/from the selected date. Please see how to calculate dates with the add-in in this part of the manual above.
If you have any other questions, please do not hesitate to ask.
Can you have two date pickers on one sheet? I am struggling making them both work.
Thank you for your comment and for using Date Picker. Unfortunately, there is no way to have two Date Pickers on one sheet, we didn’t even think of such a use case. Could you please explain in more detail why do you need two Date Pickers on your worksheet? We will think of a way to help you.
Can you include week numbers i.e. week 46, week 47 etc, in the pop up calendar? I just discovered albebits and I think it is great. It has made my job a lot easier. Thank you
Thank you so much for your comment, it is very inspiring for us to know that our work really helps!
And thank you for the suggestion on showing week numbers in the calendar. I have passed it to our developers and in the coming updates we will implement this feature.
Is it possible to embed the date picker in the cell so that users without the add-in will only need to pick a date from the calendar? I am creating a form for our company users and I want to have a calendar for them to pick a date instead of keying it in.
Thank you for using Date Picker and for an interesting question. Unfortunately, it is impossible to embed Date Picker in the cell and make it appear on the machines that do not have the add-in installed. I believe that you may find a solution of your task here, maybe one of the described ways to create a calendar in Excel will work for you.
Is there a way thet the excels "Worksheet_Change(ByVal Target As Range)" can recognise that the date picker has changed the value of the cell in that range
Thank you for using our product and for your question. Unfortunately, no, because no work change event occurs when Date Picker changes the value.
Please feel free to contact us with any other questions.
Is there a way to have the cell default to the calendar? i.e. when you click the cell, the calendar to select the date automatically pops up?
Thank you for using our product.
In the current Ultimate Suite version, there is no such an option to make the calendar pop up automatically. I will pass your question to our developers and maybe this feature will be introduced in the coming release :)
Is there a way to customize how the date is initially displayed in excel without having to change after the date is picked? Preference is dd-mmm-yyyy (12-Jul-2018).
Thank you for your question! Now you can’t do that, but in our coming update of Ultimate Suite for Excel, we will fix it. Date Picker will use the format of the cell initially selected. So first you will have to format your cell as Date 12-Jul-2018, and only then pick a date in the Date Picker calendar.
Thank you for helping us become better!
How do I apply the date picker to an entire row? I can only get it to apply to one cell at a time. I need to send form out and need about 300 people to fill it out and need them to be able to select a date in an entire row.
Unfortunately, there is no possibility to apply Date Picker to an entire row. The tool works for only one cell at a time. We are sorry it can't help you with your task. We will look into the possibility to implement this feature in our future releases.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!