title: Sort Google Sheets spreadsheet by date, not by string
body: <p>I use Google Sheets to keep a list of applications I am doing. In each row there is a date field. I want to sort by date now. The first row is frozen using <code>View - Freeze - 1 row</code>. When I select the whole table, press <code>Data - Sort range...</code> and then check <code>Data has header row</code> the sheet is sorted. But not by date but by string. The format of the cells is date. Is only string sorting possible? If yes, I would have to reformat the whole document to dates like <code>2017-01-11</code>, correct?</p>