I have a basic Excel 2013 spreadsheet I use to track appliance retirement for an apartment complex. I am trying to get a column to sort by months for a give year. This is currently what I see:
What I would like to have is all the months grouped by year. This will allow me to see what appliances I have for retirement in a given year.
Example of what I am trying to accomplish:
As it stands now it sorts only by month and not by year. I can not for the life of me determine how to accomplish this. A lot of Googling seems to point to a pivot table but this seems like something that should not require that level of complexity to accomplish. The column is formatted for a date value. Can anyone point me in the proper direction to accomplish my goal?