Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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 '13 at 19:26
Can you share a doc with us? – Jacob Jan Tuinstra Dec 13 '13 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 '13 at 23:40
up vote 1 down vote accepted

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

share|improve this answer

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

share|improve this answer
Good workaround. However, still, cannot select today is annoying. – Eric Yin May 14 '14 at 16:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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