Assume that you want to make a birthday calendar for the above list🎉
Then, you have to ignore years and consider only the dates and months to sort dates.
First, you have to use a helper column and create each source date with the same year.
You can use the below DATE formula for that.
You can use any year you like. In this case, it is 2023.
You can use the MONTH function and the DAY function to get the month and the date.
Next, you have to sort records using the newly created separate column (Column D).
Using the format code dd-mmm, you can change the date format to hide the year of each new date🤩