0

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
0

0