As I pointed out the sort function works only if each entry is on its own row.
Rather than retyping the entries you can bring the data onto single rows with three simple formulas.
Here is some sample data. Note that some entries take up three rows and some four rows.
A B C D
2 las village tao(las) 12/01/07 BE
5 lat taigdo(lat) 10/07/05 12 pass
9 lap village tass 11/06/06 MA
Make a backup copy of your workbook before starting this.
First insert three extra columns before the date column. The dates will now be in column F
Enter the following formulas in the empty cells for the first entry. If your data does not start on Row 2, adjust the formulas accordingly.
The reason for the different formula in E2 is to take account of entries that take up either 3 or 4 rows.
Drag the formulas in C2 to E2 down to the bottom of all your entries.
There will be lots of extra data showing, but that will be dealt with during sorting.
Now select all your data.
Copy all data, then Paste special - Values. This will remove the formulas as they are not needed anymore.
Next, sort the data using the date column.
Below the last proper entry will be all the extra data, and this can be selected and deleted.
The sorted data will look like this:
A B C D E F G
2 lat taigdo(lat) Ap cist Polo 10/07/05 12 pass
3 lap village tass yupia AP 11/06/06 MA
4 las village tao(las) p/pare AP 12/01/07 BE