In this video, I will show you two simple formulas to sort dates by months in Excel.

While sorting dates is easy in Excel (as dates are stored as numbers in the backend), what if you want to sort dates by month (irrespective of the year value)?

This can be done using a simple formula.

In today’s video, I will show you two simple ways to sort dates by month in Excel (using the SORTBY function and a helper column technique).

️ Read the article – https://trumpexcel.com/sort-dates-by-month-excel/

️ Download Example File – https://www.dropbox.com/scl/fi/ci3noss1lwg195hakmu8e/Sort-Dates-by-Month.xlsx?rlkey=wfkgaze1sar6szwhl9w8ku4bh&dl=1

00:00 Intro
00:22 Sort Dates by Month using SORTBY formula
02:08 Sort Dates by Month using Helper Column

If you find my Excel videos useful and would like to support me, you can buy me a coffee – https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
Free VBA course – https://bit.ly/excel-vba-course
Free Power Query Course – https://bit.ly/power-query-course
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial #SumitBansal

Please take the opportunity to connect and share this video with your friends and family if you find it useful.