Excel Won't Sort Dates Correctly - The Solution!

[@ArafatHossainAbir]

Sir, You will be remembered till my death. It took 7 minutes to understand this. Thank you so much.

[@TheTechTrain]

Ha ha! Thank you so much, I'm very glad to have helped.

[@jgnolen20]

@@TheTechTrain What if I'm trying to do a multiline sort? it doesn't seem to work. My date is a date per the true-false test, and I can sort the date column correctly with the a-z button. However, when using a multiline sort it does not work... Any ideas?

[@simonanlezark3042]

@@TheTechTrain I'm also having the multi-line sort problem :( This solution had me excited until I tried it with an advanced sort

[@teem5945]

I don't think he will ever fathom the number of hours of work he saved us. Indeed, knowledge is power.

@@TheTechTrain 😂

[@henryelicker2403]

Wow, it's rare to find a video that actually fixes stuff on Excel, and yours did. Thanks man!

[@rferia539]

This is the first of like 15 different sites and videos that did this properly. Everyone else took the easy way out by only having one year. Thank you for explaining this properly!

[@TheTechTrain]

I'm so glad you found it useful.

[@GuteisFinger]

Completely useful and what enormous frustration you cured with very straightforward and easy to follow steps with no added filler. Thanks!

[@stevenstaley8904]

Thanks for this fix. I refer to it every year when preparing my books to take to my accountant. I have usually forgotten the correction method by then. Your explanations are lucid and your voice timbre easy on the ear. Thank you. We tech-blockheads need people like you!

[@tatakatakashi]

Thank you! This video sorted my issue! The big secret was just to make sure none of the delimiters were selected in the Text To Column dialog box and that when you select the date there you select WHAT IT CURRENTLY IS, rather than WHAT YOU WANT IT TO BE, as I had been doing, as you change it to what you want it to be after it's properly formatted as date. Thank you again!!

[@angelarce8160]

More than 3 years later and this video is still relevant. Thank you so much for this! I've been racking my brains out for a solution! This solved my problem!

[@TheTechTrain]

I'm so glad you found it helpful Angel Arce

[@jithendratchemistryskpgdc9857]

Excellent, I have been struggling for solution with this problem . Consulted with my colleagues but in vain, Problem solved with your suggestion . So great of you. Thank You

[@BenryDess]

Saved me about four days' work on my master's thesis. Thank you!

[@timreed1327]

I have struggled with this for three days - I got the solution from you in a couple of minutes but watched the whole thing anyway! I was using the text to coloums but not removing all the qualifiers! Thanks!!!!!!!!!!!!!!!!!!!!!!!!!

[@MarcHavermans]

After trying to figure this out for 3 hours I am so happy that I found your video! Thanks mate!

[@TheTechTrain]

You're very welcome!

[@Chibsony]

😂😂😂😂 literary my predicament

[@cmere76]

Have spent ages trying to find out why this wasn't working - thank you SO much for this video! 🙂

[@Bowie5386]

I love you. I saw someone type out these instructions and when I followed them they didn't work. That person never specified to deselect things in the delimiter column. Anyway, when my dates moved to the right I gasped so loud that I scared my cat. It has been DAYS since I started working on this spreadsheet and I was about to give up and just deal with them unsorted

[@rhubert2539]

I usually just get the info I need and move on but wanted to take the time to say thanks for providing value to your subscribers & those of us who found you in desperation!!

[@TheTechTrain]

Much appreciated! I'm very glad you found it useful.

[@OMjosh123]

YOU'RE OUT HERE SAVING LIVES!!!!!!!!!!

[@sonya1602]

God bless you! I have a report due tomorrow first thing in the morning and I was able to sort the dates on my pivot table thanks to your tips. Truly!

[@marcogiordano5184]

You are a genius my friend...thank you SO MUCH for giving clear instructions on how to solve this very annoying issue

[@jackbrent6796]

You are a star, I was beginning to think I'd have to sort thousands of lines of data out manually. Thank you sooo much.

[@oohsusieq206]

This is exactly what I was looking for! Thank you so much.

[@kondalanaidu5471]

Yah exactly ,I use this idea on today my self also

[@Shivam_0786]

Yeah i am also looking for

[@harry27840]

Thank you! Exactly what I wanted is sorted out 👌🏽

[@riteshsahare86]

Me too

[@nickkie1226]

Thank you, I was going crazy trying to figure out why my dates were sorting by months and years! And now I have the new tool of knowing when to check if the field is True or False for text!

[@analisakushinga8661]

Such a simple ,clear and understandable video. Thank you so much.

[@joannafowler2794]

I can’t believe I spent so long trying to sort this before seeing this video! Fantastic tutorial! Thx

[@TheTechTrain]

I'm so glad you found the tutorial helpful! It can be frustrating to spend so much time sorting before finding the right solution. Keep up the great work!

[@fatmahabdallah987]

Thank you so much for this tutorial. I have been battling with sorting my accounts. Now I finally can complete them

[@TheTechTrain]

I'm so glad you found it useful Fatmah! Glad to have helped with your accounts.

[@jenniferchiamaka6217]

Thank you very much! I have been trying to format some date in my file for days which has left me frustrated until I came across this video. Very straightforward.

[@ekenne001]

Legend been trying to sort this for so long!

[@primeworldphotoshoptutoria2487]

O MY GOD.... This was so incredibly well explained and so helpful... i am almost in tears. God bless you so much sir and thank you greatly

[@AndyDay]

My god, I hate Excel SO MUCH. Why does this error even exist? I set my column do Date format before I entered any data and STILL I had this problem. It makes no sense! That aside - thank you! Life saver.

[@TheTechTrain]

Thanks, I'm glad it was useful

[@satoshinakamoto171]

its not excels problem. its most likely the file that you get from the erp that mutates the dates

[@DroneNewsGuy]

Brilliant man! Even 2 years later you're still saving the world! Thanks very much for this!

[@goabaonentsimane2951]

I saw 5 years ago and didn’t trust this video at all… This video has stood the test of time… I just impressed my boss…. thank you 🙏🏽

[@kellygarrett8619]

What an incredibly useful video. Man, I searched forever for thaat answer. Great work.

[@saurrabhsinghkushwaha4684]

All glories to the master!!!! It took me 1hr to figure out. After watching this video, i am extremely happy!!! Thank uuuuuuuu sooooo much

[@Paleto14]

AWESOME!!! FINALLY, an easy solution to a problem I get every time a client sends me their Excel file.

[@TheTechTrain]

Glad it helped!

[@JoannaFoley]

You're the Best! Like many others, I've spent at least an hour trying to find out how to fix the problem. Project for work is now complete thanks to you.

[@TheTechTrain]

Thank you Joanna Foley, I'm so glad you liked it.

[@WaJiDsaleem]

It worked for me, thanks to your easy steps I’ve managed to avoid big chaos in a report. This saved my day.

[@Ohmynene]

This is the first video that actually helped me and I’m in the US! It was the text to columns that I needed to fix. Thank you!!!! 🙌🏾🙌🏾🙌🏾

[@TheTechTrain]

I'm so glad it worked for you! Hello to the US! 👋

[@ajmoore8293]

Bless you! I have been tearing my hair out over this for an hour. The Microsoft Tech Help had NO idea how to sort it. I had my suspicions that it was some kind of bug. I could not believe that Excel designers had just decided to do away with such a useful function. The alignment (left instead of right) of the dates is the giveaway. Although, how I shall remember how to solve it next time I need to do it ... You explain it clearly, but an ordinary user would never think of such a thing.

[@TheTechTrain]

I'm so glad you found it helpful AJ Moore

[@katherinelawrence1608]

wow. This video saved the day! I especially like how you get to the point and explain why in under 9 minutes!

[@suzzi1961]

I had over 700 transactions in one of my spreadsheets and guess what your brilliant......I was able to sort the info using your instructions. They were clear to understand and easy to do...Thank you for Sharing this info...Regards, Sue from Brisbane Australia.

[@TheTechTrain]

I'm so glad it was able to help you!

[@sherylpatterson1552]

This may be an 8 year old video, but it worked in 2024!! I can't tell you how much headache this saved me.

[@dineshk6405]

I did have an irritating problem sorting the dates, your video has managed to fix that for me. Amazing work, loads of love

[@arjuna19768]

Thank god I stumbled upon this video. This will help me sort out a number of issues in 2024. Thank you!

[@TheTechTrain]

I'm so glad to hear that this video is helpful for you! Wishing you all the best in sorting everything out in 2024!

[@passion1013]

It has helped me very much. I didn't find any solution for this problem. But finally I got this video with the solution. Thank very much.

[@VTgirlandherbeagles]

I know this is seven years young, but THANK YOU! It's still relevant and very much helpful.

[@TheTechTrain]

Glad it was helpful!

[@VakarianGirl]

You are my hero. Thank you. I have been mishandling massive Excel spreadsheets at my work now for months because of this issue. THANK YOU!!!!

[@TheTechTrain]

You're very welcome VakarianGirl, I'm so glad you liked it.

[@ramah95]

Really helpful and fixed my issue which I spent hours looking through youtube without luck. Thanks a lot.

[@AlimPrincess]

Many articles tell you to change the cell format, but the issue isn't resolved after doing so. Thank you for sharing with us the true fix for the problem!

[@TheTechTrain]

I'm so glad this was able to help!

[@sisasenkosimbambo95]

Oh my goodness!!! You are simply HEAVEN SENT!!!! This fixed up an error in my database in seconds. Thou art AWESOME!!!!

[@TheTechTrain]

Thank you so much! I'm really glad I was able to help fix the problem.

[@IBtrollinyoufool]

Man! I was going crazy until I watched this video! Thank you for solving my problem!

[@jorgezubizarreta142]

You are the best thing that happened to me this day! I have been trying to figure out this for ages!!!! Was about to go crazy! Thank you from Argentina!!! God bless you!!!

[@jamespyburn8133]

Thank you I spent hours trying to find out what was wrong and the true/false check and your solution worked. XL said dates but they were not recognised. I had 400 dates from a company accounts program that I wanted in XL. All now sorted!

[@trondss1]

Thank you! For some reason this video is still relevant six years after release. MS should fix this!

[@StrugglerIndeed]

Excellent! Never would have gotten this without this video. Mine is properly ordered by date now.

[@TheTechTrain]

I'm so glad it helped fox your problem.

[@GS-qvis]

This has been driving me insane, forever. Thank you, not only for the solution, but the tempo and explanation was great.😊👏

[@melvinrijlaarsdam4337]

Awesome, googling for half an hour didn't give me a solution, this video hit the spot!

[@TheTechTrain]

Glad it helped!

[@cilvagold]

OMG, I've waisted more than an hour trying to figure this thing out. Thanks a lot man.

[@priyankasonawane118]

I spend a day tackle this problem. This video helps to solve my problem quickly. Thanks for uploading awesome solution.

[@karendonnell8869]

Oh my goodness, this was exactly what I've been trying to do and it's been so frustrating trying to get this to work. Thank you so much for sharing this!!!

[@lindsayk3599]

Excellent!!! Was looking all over the place for a solution to the issue after downloading a CSV file. You nailed it. Thank You!!

[@TheTechTrain]

I'm so glad it worked for you!

[@ibrahimx28]

Thank you. Solved my dating issue. While my social dates still are problematic, at least you solved my Excel dates.

[@TheTechTrain]

I have problems with dates too... I feel your pain!

[@sharukhjamal2627]

This issue was so frustrating, thank you! Your solution worked like a charm! GOD BLESS YOU!

[@gmpatagonia]

Very impressed! It was exactly what you described. It was recognise as text. Changed via 'text to column' and it worked. thank you

[@TheTechTrain]

I'm so glad it helped!

[@TheHgfj]

I watch multiple videos before coming here all in vain.. thanks for the superquick solution. Appreciated!!

[@qinrongwu9603]

This video save my life!!!!!!!!!! EXTREMELY HELPFUL!!!!!!!! Thank you so much!

[@TheTechTrain]

You're very welcome! I'm glad it worked for you.

[@agnesbenko8873]

I watched a previous video by someone else but it did not solve my problem. After watching your video my problem with the date sort was solved. Thank you!

[@tye9]

This is the best video in the history of video's. Thank you very much for making my day 1000x easier

[@priyabhattacharjee421]

You saved me hours of manual work, endless thank you!!

[@ajeeshca88]

Thank you very much Man after 8 years of uploading this video :). really helped.

[@TheTechTrain]

Glad it helped!

[@jawadali6853]

You sir deserve my subscription :P Tried so many videos and it seems they all had the same solution and didn't work for me. Your solution resolved my problem. Thank you :) Keep up the good work

[@KathyKay-97]

Thank you. The explanation was what I needed after several searches

[@TheTechTrain]

Glad it helped!

[@tridibbiswas3361]

Thank you so much. I just happened to stumble upon this video and channel. I was trying to find a solution for this for past few months and finally given and used power query to solve , which I always felt an overkill for simple issue.

[@TheTechTrain]

Glad it helped!

[@alebarthe1836]

Wow! A video that actually solved my problem, easily and quickly. Thank you!!

[@TheTechTrain]

You're welcome!

[@kampunpolym4461]

You are genius. Thank you for help. I have checked so many solutions out there flooding on Google but none worked or relevant to my issue. You made my day. Thank you once again from Bharat(earlier India).

[@CheragBhatia]

Amazing video saved 2 hours of manual work!!!

[@TheTechTrain]

Glad it helped!

[@MendoFilm]

Wow i never thought id find the solution to this. I know ill be a hero at work when i share this with some coworkers!

[@DanielNikolla3]

YOU'RE A LEGEND! BACK FROM THE FUTURE

[@TheTechTrain]

Thank you Daniel!

[@dandenning6499]

Thank you so much, been searching around for a simple explanation like this!! Solved :) everyone else made no sense at all and this is a really simple fix!

[@cherylp2826]

Thank you!!! This is just what I needed to solve this issue. I had been trying to use text to columns and then a concat formula but nothing was working. You have made my life a lot easier and saved a bunch of time :) Thanks!

[@TheTechTrain]

Glad it helped!

[@susannepartoll171]

Thank you, this was very helpful! It saved me hours of desperation!

[@TheTechTrain]

Glad it helped!

[@innaalmira2580]

I have been stressing whole day !! This video saved my life !!! THANK YOU SO MUCH ♥️♥️♥️♥️♥️♥️

[@fbarakeh]

excellent solution .... the best solution on KZbin to solve the sorting error in excel ...

[@KirkThomson]

Awesome!! This has frustrated me for ages! Thank you so much!!

[@TheTechTrain]

Glad it helped!

[@madhuridevkate3308]

After so many effort I found this video and it's really works .Thanks a loooot👍

[@TheTechTrain]

Glad it helped!

[@yusufjohnson9357]

This was very helpful, and solved a problem that was costing me a lot of time!

[@TheTechTrain]

I'm so glad it helped you!

[@belenbee]

Thank you so much, I used to overlook this issue but now I really needed those days sorted, you saved my report!

[@jericomedayo8714]

Good thing I found this! My problem is all sorted out!

[@mlowe4715]

Well Done. Great Video. My colleague at work was delighted when I stumbled across this revelation. Many thanks for that Video. I Googled it online and found that so many people are pulling out their hair trying to find a solution to this. I'm glad I found it here. Thank you.

[@annamayer2284]

Dear Tech Train, You absolutely made my day. Thank you so much for this video!

[@karenmclaughlin7129]

Thank you SO much for this solution. Your tutorials are excellent. I know where to come in future!

[@TheTechTrain]

Thank you Karen, I'm really glad you think so!

[@WWEEZZYY]

so helpful! this issue has been a real problem for me, for a long long time. Thank you!

[@TheTechTrain]

I'm so glad this video was able to help you!

[@KTKRULL]

I wish I would have watched this video 5 years ago. Radical. Also - great little facts in there like text defaulting to left orientation.

[@Davina_Meyer]

Thank you. This video was really helpful after I had been struggling for the past two days😅

[@TheTechTrain]

Glad I could help!

[@uchechukwurosemaryomechi342]

Just what I needed. Finally got a way to solve my date problem. Thank you very much

[@amothersopl3466]

A very very clear explanation. Thank you so much. Learning thru your videos here in the Philippines. Thank you so much🤩🤩🤩

[@jonplackett4494]

Really useful, easy solution. Was driving me crazy before watching this!

[@TheTechTrain]

I'm so glad it was able to help you.

[@margaretpacitti4028]

Thankyou so very much, you fixed my problem! I've been trying to fix it for weeks and other videos haven't helped.

[@TheTechTrain]

I'm so glad you found it helpful MARGARET PACITTI

[@1990SammieJ]

I actually love you! Thank you!!!!!!!!!!!!!!!!!!!!!! I just spent 5 hours wrestling with excel until you came along, you brilliant man!!

[@TheTechTrain]

Ha ha! You're very welcome, I'm so glad I was able to be of some help in recovering your sanity.

[@gulrukh5423]

Finally... Strategy that work... Thank you man

[@TheTechTrain]

Glad it helped

[@mechanismoftechnologyptylt3815]

I know you did this video 7 years ago but THANK YOU.

[@patstaley8195]

Thank you, Thank you Thank you! I have struggled with this for years. This was clear and concise!

[@TheTechTrain]

Glad it helped!

[@flamezilla]

You are a legend I have been struggling all day May God BLESS YOU