3

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?

Improve this question
3
  • 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
    Commented Sep 26, 2013 at 19:26
  • Can you share a doc with us?
    – Jacob Jan
    Commented 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
    Commented Dec 16, 2013 at 23:40

2 Answers 2

Reset to default
1

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

Improve this answer
0

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

Improve this answer
1
  • 1
    Good workaround. However, still, cannot select today is annoying.
    – Eric Yin
    Commented 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.