Easy Trick to Sort Dates by Month in Excel (Formulas)

[@IvanCortinas_ES]

Excellent solution. Thank you, Sumit.

[@trumpexcel]

Thanks Iván

[@ShivakumarShivu-x2d]

Tq sir

[@londondisc]

Sumit, One bank download of transactions sends Date in Text with 2 leading blanks. To convert to proper date I use import from text than show text date column as Date on the import to convert to Date. Is there a quicker way avoiding Import from text?
Many Thanks

[@venkatrooney9912]

Awesome sumit, will you upload m and dax video?

[@trumpexcel]

I will be doing some M videos soon. I know a decent amount of M, but I am learning more advanced concepts this month and hopefully I can start making videos next month onwards

[@venkatrooney9912]

@@trumpexcel sure sumit, waiting!

[@soundaryasuresh1845]

Sir can't access the data file of your dashboard videos. Could u pls make it accessible so that we can download the data set

[@trumpexcel]

Sure... will check all the links and make the download files available. On the road, so will do this as soon as I am back home.

[@soundaryasuresh1845]

@@trumpexcel thank you sir

[@lgvdbroek]

Faster and easyer
On C2 the formule =month(B2) result : 1
On D2 the formule =day(B2) result : 4
Drop down the formulas and then sort first on column C and then on Column D..........Done.

[@vishalkatti]

You don't need to convert to number as MMDD as text A-Z will sort in right order.

[@trumpexcel]

True, but it shows a warning that could be a bit confusing, and also A to Z is not very intuitive. So I converted into numbers to avoid any confusion

[@ParamChawla-x5z]

Thank you Sumit

[@somasekhar4748]

Nice 👍

[@sunitasegran8288]

Thank You,Sumit for providing such helpful excel tips.

[@trumpexcel]

Thanks Sunita... Glad you found the video helpful :)

[@Dreotor]

Thanks a lot. I knew how to do that with helper column, but first method is way better👍

[@rahuldewangan2086]

You can also sort by month using custom sorting option

[@vencislavvankov4897]

I didn't know that (--) could convert to a numeric value! I use VALUE . I really liked this!

[@trumpexcel]

Yeah, this is a good trick in many situations