Date Picker in Excel

Date Picker in Excel
Last Updated on 21/05/2024
Reading time: 3 minutes

Use the Date Picker in Excel it's the best way to fill in a date without error. Right now, Date Picker is only available with Excel Online.

  1. Open Excel Online

    To work with Excel Online, you must open a browser (Edge, Chrome, ...) and connect with your Microsoft Account

  2. Format your cells to the Date format.

    The Date Picker opens automatically when the cell's format Date. Otherwise, it won't pop up.

  3. Select day, month, year, decade

    The date picker helps you to select any date quickly by changing the month or the year.

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.

Change the cell format to Date

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
Date Picker in Excel

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
Change months with the arrows of the date picker

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
Change months from the year of the Date Picker

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
Move quickly to another year with the data picker

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
Date Picker by decade

Return to the Date of Today

Go To Today Date Picker

Leave a Reply

Your email address will not be published. Required fields are marked *

Date Picker in Excel

Reading time: 3 minutes
Last Updated on 21/05/2024

Use the Date Picker in Excel it's the best way to fill in a date without error. Right now, Date Picker is only available with Excel Online.

  1. Open Excel Online

    To work with Excel Online, you must open a browser (Edge, Chrome, ...) and connect with your Microsoft Account

  2. Format your cells to the Date format.

    The Date Picker opens automatically when the cell's format Date. Otherwise, it won't pop up.

  3. Select day, month, year, decade

    The date picker helps you to select any date quickly by changing the month or the year.

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.

Change the cell format to Date

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
Date Picker in Excel

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
Change months with the arrows of the date picker

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
Change months from the year of the Date Picker

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
Move quickly to another year with the data picker

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
Date Picker by decade

Return to the Date of Today

Go To Today Date Picker

Leave a Reply

Your email address will not be published. Required fields are marked *