I'm trying to sort dates in Google Sheets and ran into a problem.
I have many dates consisting of a day and month. DD/MM
When sorting sheets does this:
- 01/01
- 01/02
- 03/02
- 04/01
- 07/01
- 09/02
- 15/01
- And etc..
I'm trying to sort by date and not by the day of the month. Can anybody please help me sort this out?
My goal:
- 01/01
- 02/01
- 07/01
- 08/01
- 15/01
- 4/02
- 8/02
