Your cell's format must be a Date

To use the Date Picker, with Excel Online, you must change the cell format to Date (long date or short date) from the ribbon.

Date Picker of Excel in action

Here is a series of situations where the Date Picker helps you to select any date.

How to select a date in the current month?

1. Go to the cell where you want to add a date.
2. Write any number or double-click.
3. Then, the Date Picker appears in your worksheet
4. Select any date in the calendar
5. Finally, the cell displays the selected date and the calendar has disappeared

Select a date in another month with the Arrows

1. Go to the cell where you want to add a date
2. Double-click to open the Date Picker
3. Use the arrows to change the month
4. Select your date in the calendar

Select a date in another month with the Year

1. Go to the cell where you want to add a date
2. Double-click
3. Click on the year to display all the months for this year
4. Select the month you want
5. Select your date

Use the Date Picker for another Year

1. Go to the cell where you want to add a date
2. Double-click
3. Click on the year to display all the months for this year
4. Use the arrows to select the year you want
5. Select the month you want
6. Select your date

Select a date in another Decade

If you want to select a date long time ago, you can display the Date Picker of Excel by decade

1. Go to the cell where you want to add a date
2. Double-click
3. Click on the year to display all the months for this year
4. Click one more time on the year to display the decade
5. Use the arrows to select the year you want
6. Select the month you want
7. Select your date

Return to the Date of Today

Related Articles

• Displaying Date and Time in the Same Cell
• How to build your dynamic dates in Excel
• Convert a Text Date to a Number Date