How to Sort Dates in Excel


To sort data by year in excel you’ll need to select the data.

sort data by year in excel

Right click and select format cells.

right click and select format cells

Then you’ll need to select the custom option.

select custom

In the custom option pop up you’ll need to input yyyy/m/d in the type bar.
Once you’re done click ok.

input yyy/m/d in the box to the right and click OK

This will then arrange the data in that format. With the data selected choose the sort function at the top. It will now sort your excel data by year.

click on the format option and choose to sort by year