How to sort dates by Month and Day instead of Year in Excel

Subscribe to my channel and unlock exclusive benefits!
@ASVExcel

By default, Excel doesn't have the functionality functionality to sort dates by months and days. However, there is a simple workaround to achieve this.

🎓 What You'll Learn:
• How to create new columns to extract months and days from birth dates.
• Using the MONTH and DAY functions in Excel.
• Sorting data by month and day to create a birthday calendar.

📌 Key Takeaway:
• Learn how to effectively sort dates by month and day, enabling you to create useful calendars for better planning and organization.

If you liked the video, give it a thumbs up, and subscribe to my channel for more useful Microsoft Excel lessons.

Timecodes:
00:00 - Introduction
00:18 - Sorting challenge introduction
00:59 - Using the MONTH and DAY functions
01:33 - Sorting by month and day
02:12 - Summary and applications

[pinkzx]

Thank you! I have needed to simplify this for the longest time and you helped me do it in seconds!