Using date picker

Date picker allows you to choose a date from a calendar pop-up window. To use date picker in Google spreadsheets, double click a cell that has a date in it.

Date picker

Date picker recognizes dates with a month-day-year format if the spreadsheet locale is set to the United States. If you'd like to use date picker to format your dates as day-month-year, set spreadsheet locale to a different country (File > Spreadsheet settings...).

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?