Or click the Date Picker icon next to the selected cell. Select a cell that contains the date you want to use for calculations, right-click it and choose the Select Date from Calendar option in the context menu. Excel Date Pickerĭouble-click the needed date or press Enter to have it inserted into the cell and close the calendar. How to insert a date into a cell Right-click any cell and pick the Select Date from Calendar option in the context menu. To turn off Date Picker, click its button on the ribbon again. Besides, you can open the drop-down calendar if you right-click a cell and choose the Select Date from Calendar option. Date Picker will assist if you need to add and subtract years, months, weeks, and days from the chosen date and paste the result into the chosen cell.ĭate Picker is enabled, so now each time you select a cell with a date you will see the Date Picker icon on the right. Just run the calendar and click the needed date to get it automatically inserted into the selected cell. Thank you!Date Picker is a drop-down calendar that helps entering dates in Excel. I have bought two packages for both work computers. Ever since I found your add-ons, it has been a life saver or should I say a major time saver. Plus, Ablebits' support is reliably fast and courteous. I like the ability to merge tables based on 1 or more attributes, transpose columns and rows, and to transform data with Cell Cleaner utility.

I've been using Ultimate Suite for almost a year and found it invaluable for my projects. But I'm just a religious user of AbleBits. There're things I just can't complete any other way in large datasets.

Changing jobs, I get my new employer to cough up the very reasonable cost of this software. I use AbleBits every day and keep finding new uses. I often deal with huge tables and matching between versions has always been a nightmare. I talked my supervisor into getting Ultimate Suite. Love the products! They have saved me thousands of hours and they are responsible for me getting a promotion at my last job, which helped me land my current position as a manager.

Easily add and subtract years, months, weeks, and days from a date and get the result put into the needed cell. When you pick the date in the calendar, it is automatically inserted into the selected cell. Just run the add-in and get your calendar right in the worksheet. No need to enter dates in Excel manually anymore - the Excel Date Picker tool is out.

Ablebits date picker for excel