How to work with Date Picker in Excel

How to turn Date Picker on and off

1. On the Ablebits Tools tab, in the Date & Time group, click Date Picker:
   

   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.

2. To turn Date Picker off, click Date Picker on the ribbon again.

How to insert a date into a cell

Right-click any cell and choose the Select Date from Calendar option from the context menu:

Here is the Date Picker pane:

1. Click the Date Calculator icon if you need to add or subtract dates.
2. With the Two-month view icon, you can expand the Date Picker pane to two months. To get back to the one-month view, click the double arrow once again.
3. Click the Today icon to switch to the current date in the calendar.
4. The Up and Down icons will help you navigate between months.
5. Use the Undo icon to cancel your choice and return the value that was in the selected cell previously.

Double-click the needed date or click it and press Enter to insert the date into the selected cell.

Tip. Click the month name to switch to the year view, and click the year to switch to the decade view:

How to calculate dates in Excel

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:

1. When you run Date Calculator, the addition (+) is chosen as the default operation. If you need to subtract dates, just click the minus sign (-). You can also use the corresponding buttons on your keyboard.
2. The result of the calculation.
3. The units you can add or subtract.
   Tip. To comfortably move between YEARS/MONTHS/WEEKS/DAYS, use the Left and Right arrow keys on your keyboard. You can also press:

   • The Y key for years
   • The M key for months
   • The W key for weeks
   • The D key for days
4. The Backspace icon. Click it to cancel entering the last digit or press Backspace on your keyboard.
5. The Clear icon. Click it to remove the last entered digit. Double-click this icon to remove the whole entry.
6. The Show result in calendar icon. Use it to display the calculated date in the calendar.
7. Click the Put result to cell icon to insert the result into the selected cell.

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.

A quick way to calculate a date

1. Select a cell with the date you want to use for calculations and click the Date Picker icon next to it.
2. Press F4 to open the Date Calculator pane.
3. Perform the necessary calculations.
4. When you see the desired result on the Date Calculator pane, press Ctrl+Enter and get the resulting date pasted into the cell that was initially selected.