In a Google spreadsheet, when having a cell formatted as date, or with a data validation set on date, a date picker appears when double clicking this cell.

If the cell is blank, the picker's date is pre-selected to today's date but I cannot select it. I need to first select an other date, open the picker again and then I can select today's date.

Does anyway know how I could select the highlighted date in the picker?

  • I believe it's a bug. I would submit a bug here - support.google.com/drive/?hl=en#ts=2624997. Go to > Contact Us
    – Blexy
    Sep 26, 2013 at 19:26
  • Can you share a doc with us? Dec 13, 2013 at 21:15
  • @JacobJanTuinstra just create a sheet, set a cell "data validation" to Date. Then try to select today's date. That's it.
    – oldergod
    Dec 16, 2013 at 23:40

2 Answers 2


Google seems to have fixed this bug. I tried this morning and no problem.


Don't use the date picker for today, instead Ctrl+;, validated or formatted or not.

  • 1
    Good workaround. However, still, cannot select today is annoying.
    – Eric Yin
    May 14, 2014 at 16:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.