Kala soocida xogta taariikhda waxay u egtahay inay tahay hawl fudud, iyo, runtii, Microsoft Excel waxay bixisaa dhowr siyaabood oo lagu kala saaro xogta taariikhda. Si kastaba ha ahaatee, mararka qaarkood qalabka kala-soocidda ee Excel si sax ah uma shaqeeyaan, taasina waxay noqon kartaa mid niyad jab leh. 

Halkan waxaa ah dhowr siyaabood oo lagu kala saaro taariikhda gudaha Excel , iyo sidoo kale khiyaamo lagu tijaabiyo haddii taariikhuhu aysan si sax ah u kala soocin.

Kala soocida Hal tiir^{(Single Column)} oo Taariikhaha^(Dates) gudaha Excel 

Habka ugu fudud ee loo kala sooci karo taariikhaha gudaha Excel waa in la isticmaalo qalabka kala-soocidda si aad u muujiso taariikhaha sida aad rabto. 

1. Dooro tiirka taariikhaha adigoo gujinaya madaxa tiirka. Sawirka hoose , waxaanu ku dooranay tiirka annagoo gujinaya madaxa tiirka A.

1. Waxa kale oo aad dooran kartaa oo kaliya unugyada gaarka ah ee tiirka kuwaas oo leh taariikho iyaga.

1. Marka xogtada la doorto, ka dooro Kala soocida & Shaandhaynta^{(Sort & Filter)} liiska Guriga.

1. Hadda kala dooro midka ugu da'da weyn ilaa^{(Sort Oldest to Newest)} kan ugu cusub ama kala sooc kan ugu da'da weyn^{(Sort Newest to Oldest)} . Tusaalaha hoose, waxa aanu kala soocnay mid cusub ilaa kan ugu da'da weyn. Ogow^(Notice) in Excel uusan bedelin qaabka taariikhaha balse uu si sax ah u kala saaro taariikhaha ka bilaabma kuwa cusub.

Habkani waa inuu ku shaqeeyaa inta badan kiisaska isticmaalka.

Ku kala-soocidda xaashida^(Entire) shaqada oo dhan taariikhda^(Date) gudaha Excel

Haddii miiskaagu leeyahay in ka badan hal tiir oo xog ah, waxaad u baahan doontaa inaad ilaaliso xidhiidhada tiirarka marka aad kala soocdo. Hoos waxaad ku arki kartaa taariikhaha tiirka A iyo qoraalka u dhigma ee tiirka B. 

Haddii aad isticmaasho habka kor ku xusan, (ie, xulashada unugyada taariikhda ama dhammaan tiirarka taariikhaha, adigoo gujinaya kala soocida^{(Sort & Filter )} badhanka, oo aad doorato mid ka mid ah Kala soocida ugu da'da weyn^{(Sort Oldest to Newest)} ama Kala sooci Ka cusub ilaa ugu da'da^{(Sort Newest to Oldest)} ), Excel wuxuu soo bandhigi doonaa kala soocida Digniin^{(Sort Warning)} oo ku weydiin doona haddii aad rabto inaad balaadhiso xulashada si loogu daro labada tiir ee xogta.

Hubi in Expand xulashada^{(Expand the selection)} la doortay oo guji badhanka Kala soocida^(Sort) . Excel wuxuu u kala saarayaa dhammaan xogta shaxda qaabka aad dooratay.

Waxaad arki kartaa in hadda dhammaan taariikhaheenna laga soocay kuwa ugu da'da weyn ilaa kuwa cusub, iyo xiriirka ka dhexeeya taariikhaha ku jira Tiirka A^{(Column A)} iyo qoraalka ku jira Tiirka B^{(Column B)} waa la ilaaliyay.

U kala soocida bisha^(Month) , sanadka^(Year) , ama bisha^(Month) iyo maalinta^(Day) gudaha Excel

Ka waran haddii aad rabto in aad taariikhda ku kala soocdo Excel qayb gaar ah oo ka mid ah taariikhda sida bisha ama sanadka? 

Kala soocida Taariikhaha Bil kasta gudaha Excel^{(Sorting Dates by Month in Excel)}

Shaxda tusaalaha ah ee maalmaha dhalashada dadka, tusaale ahaan, waxaa laga yaabaa inaad rabto inaad ogaato qofka dhashay bil kasta, adigoo iska indha tiraya sanadka qof kastaa dhashay. Ma isticmaali kartid qaabka caadiga ah ee Excel sababtoo ah waxay had iyo jeer ku dari doontaa sanadka soocideeda algorithm.

Si aad tan u hesho, waxaad samayn kartaa tiir caawiye ka soo saarta bisha si aad markaas ugu kala soocdo tiirkaas. Si aad bil uga soo saarto taariikhda, waxaad isticmaali kartaa shaqada MONTH ee Excel .

1. Abuur tiir cusub
2. Unugga ugu horreeya ee tiirka cusub, geli =MONTH(A1) halkaasoo A1 ay tahay unugga aad rabto inaad ka soo saarto bisha.

1. Ku soo celi^(Repeat) talaabada 2 saf kasta. Excel wuxuu bisha ka soo saari doonaa mid kasta oo ka mid ah taariikhaha, isaga oo kaa tagaya tiir lambarro bisha ah.

1. Hadda waxaad shaxda u habayn kartaa tiirka oo leh tirooyinka bisha. Xaaladdan oo kale, waxaad u kala sooci doontaa tiirka C. Haddii aad dooratid xogta ku jirta Column C , waxaad mar kale heli doontaa Digniinta Kala soocida^{(Sort Warning)} ee Excel . Dooro inaad balaadhiso doorashada^{(Expand the selection)} oo kala sooc^(Sort) .

Kala soocida Taariikhaha sanadka ee Excel^{(Sorting Dates by Year in Excel)}

Haddii aad rabto inaad soo saarto sanadka halkii aad ka isticmaali lahayd bisha, waxaad isticmaali kartaa tillaabooyinka kore, adigoo ku beddelaya shaqada bisha ^(MONTH)=YEAR(A1) halkaasoo A1 ay tahay unugga leh taariikhda aad rabto inaad ka soo saarto sanadka.

Kala soocida Taariikhaha Bisha iyo Maalinta gudaha Excel^{(Sorting Dates by Month and Day in Excel)}

Waxaa laga yaabaa inaad rabto inaad abuurto liis la soocay ee maalmaha dhalashada bisha iyo maalinta, adigoo iska indhatiraya sanadka. Si aan bisha iyo maalinta uga soo saarno tiirka timirta, waxaan isticmaali karnaa shaqada TEXT ee Excel , taasoo taariikhaha u beddesha qoraal. Waxaan isticmaali doonaa qaabka mm.dd . Raac tillaabooyinka kore, adigoo ku beddelaya shaqada MONTH qaaciidadan: =TEXT (A1, “mm.dd”) .

Hadda waxaad ku kala sooci kartaa Column C si aad u hesho liiska dhalashada qof walba bisha iyo maalinta.

Qaababka Taariikhda Cilad^{(Date Formats)} -bixinta ee Excel

Mararka qaarkood marka aad isku daydo inaad ku kala soocdo taariikhda gudaha Excel , waxaa laga yaabaa inaad ogaato inaadan heli karin Excel inuu xogta u aqoonsado taariikh ahaan. Bal qiyaas^(Imagine) , tusaale ahaan, qof ayaa ku siinaya xaashida xaashida oo ay ku jiraan taariikho. Waxaad gelisey xogta Excel , laakiin si sax ah uma kala soocna marka aad tijaabiso hababka kore. Maxay u shaqayn wayday?

Tixgeli liiskan taariikhaha:

Waxay u egtahay mid fudud oo ku filan. Si kastaba ha ahaatee, markaad doorato xogta, taabo badhanka^(Filter) Kala soocida, oo dooro inaad kala soocdo Ka ugu^(Sort) da'da ilaa^(Oldest) Kan ugu cusub^(Newest) , ma shaqaynayso! Waxaa laga yaabaa inaad ku dhameysato wax sidan oo kale ah:

Ogaysii^(Notice) in taariikhda u dambaysa ee tiirka aan si sax ah loo kala saarin. Maxaa dhulka ka socda? 

Fursadaha ayaa ah in kastoo xogta ku jirta unugga A9 ay u^(looks) eg tahay taariikh, haddana aan loo qaabayn taariikh ahaan, markaa Excel si sax ah uma xallin karo. Iyadoo ay ku xiran tahay nooca Excel ee aad isticmaalayso, xitaa haddii aad u qaabayso unugga qaladka ah taariikh ahaan adiga oo dooranaya unugga, midig-guji oo dooranaya Qaabka Unugyada^{(Format Cells)} oo dooranaya ikhtiyaarka Taariikhda , taasi ^(Date)weli^{(still )} ma xallin doonto dhibaatada.

Sida Loo Hagaajiyo Taariikhaha Aan Si Sax Ah U Kala Soocin Excel^{(How to Fix Dates That Won’t Sort Correctly in Excel)}

Nasiib wanaag, dhibaatadani way fududahay in la hagaajiyo.

1. Jar^{(Cut )} tiirka timirta adiga oo dooranaya unugyada oo Ctrl+x, ka dooro Cut from Home menu, ama midig-guji unugyada oo dooro gooyo^(Cut) .

1. Fur Notepad ama tafatire kale oo cad.
2. Ku dheji^(Paste) taariikhaha tafatiraha qoraalka

1. Ku laabo Excel , dooro tiirka taariikhihii hore loogu jiray, midig-guji oo dooro Qaabka Unugyada^{(Format Cells)} .
2. Dooro Taariikhda^(Date) oo guji OK .

1. Hadda dib ugu laabo tifaftiraha qoraalka oo dooro oo koobiy liiska taariikhaha.

1. Ku laabo Excel oo ku dheji^{(paste )} taariikhaha tiirka aad ku habaysay tallaabada 5.
2. Hadda waa inaad awood u yeelatid inaad kala soocdo. Dooro tiirarka xogta leh, taabo kala soocida^{(Sort & Filter)} badhanka sifee, oo dooro Kala soocida ugu da'da wayn^{(Sort Oldest to Newest)} . Viola! Way shaqeysaa!

Farsamooyinka Kala^(Sorting) -soocidda iyo Shaandhaynta Kale ee Excel

Hadda oo aad baratay sida taariikhda loogu kala saaro Excel , waxaa laga yaabaa inaad rabto inaad sahamiso siyaabo kale oo aad u kala soocdo oo aad u shaandhayso xogtaada. Maqaalladani waxay ku bari doonaan xogta aasaasiga ah ee hal-column iyo dhawr sariirood kala-soocidda^{(basic one-column and multi-column data sorting)} , sida loo xarfo xarfaha Excel^{(how to alphabetize in Excel)} , iyo sida loo shaandheeyo xogta gudaha Excel^{( how to filter data in Excel)} . 

How to Sort by Date in Excel

Sorting data by date seems like it should be a simрle task, аnd, indeed, Microsoft Excel offers a number of ways to sort data by date. However, sometimes Excel’s sorting tools don’t work correctly, and that can be very frustrating. 

Here are a few ways to sort by date in Excel, as well as a trick to try if dates aren’t sorting correctly.

Sorting a Single Column of Dates in Excel 

The easiest way to sort dates in Excel is to use the sorting tool to display dates in the order you want. 

1. Select the column of dates by clicking on the column header. In the image below, we have selected the column by clicking on column header A.

1. You can also just select the specific cells in the column that have dates in them.

1. With your data selected, choose Sort & Filter from the Home menu.

1. Now choose either Sort Oldest to Newest or Sort Newest to Oldest. In the example below, we’ve sorted from newest to oldest. Notice that Excel doesn’t change the format of the dates but does correctly sort the dates beginning with the newest.

This method should work in the vast majority of use cases.

Sorting an Entire Worksheet by Date in Excel

If your table has more than one column of data, you’ll want to preserve the relationships between columns when you sort. Below you can see dates in column A and corresponding text in column B. 

If you use the method above, (i.e., selecting only the date cells or the whole column of dates, clicking on the Sort & Filter button, and choosing to either Sort Oldest to Newest or Sort Newest to Oldest), Excel will display a Sort Warning and will ask you if you want to expand the selection to include both columns of data.

Make sure that Expand the selection is selected and click the Sort button. Excel will sort all the data in the table in the sort order you selected.

You can see that now all our dates are sorted from oldest to newest, and the relationship between the dates in Column A and the text in Column B has been preserved.

Sorting by Month, Year, or Month and Day in Excel

What if you want to sort by date in Excel by a specific part of the date like month or year? 

Sorting Dates by Month in Excel

In our example table of people’s birthdays, for example, you might want to know who was born in each month, ignoring the year each person was born. You can’t use Excel’s regular sort feature because it will always include the year in its sorting algorithm.

To get around this, you can create a helper column that extracts the month so you can then sort by that column. To extract a month from a date, you can use Excel’s MONTH function.

1. Create a new column
2. In the first cell of the new column, enter =MONTH(A1) where A1 is the cell from which you want to extract the month.

1. Repeat step 2 for each row. Excel will extract the month from each of the dates, leaving you with a column of month numbers.

1. Now you can sort the table by the column with month numbers. In this case, you’ll sort by column C. If you only select the data in Column C, you’ll get Excel’s Sort Warning again. Choose to Expand the selection and Sort.

Sorting Dates by Year in Excel

If you want to extract the year instead of the month, you can use the steps above, replacing the MONTH function with =YEAR(A1) where A1 is the cell with the date from which you want to extract the year.

Sorting Dates by Month and Day in Excel

Perhaps you want to create a sorted list of birthdays by month and day, ignoring the year. To extract the month and day from the column of dates, we can use Excel’s TEXT function, which converts dates into text. We’ll use the format mm.dd. Follow the steps above, replacing the MONTH function with this formula: =TEXT (A1, “mm.dd”).

Now you can sort by Column C to get a list of everyone’s birthdays by month and day.

Troubleshooting Date Formats in Excel

Sometimes when you try to sort by date in Excel, you might find that you can’t get Excel to recognize data as a date. Imagine, for example, someone gives you a spreadsheet that includes dates. You’ve put the data into Excel, but it isn’t sorting correctly when you try the methods above. Why isn’t it working?

Consider this list of dates:

It looks simple enough. However, when you select the data, press the Sort & Filter button, and opt to sort from Oldest to Newest, it doesn’t work! You might end up with something like this:

Notice that the last date in the column hasn’t been sorted correctly. What on earth is going on? 

Chances are that even though the data in cell A9 looks like a date, it isn’t really formatted as a date, so Excel can’t sort it correctly. Depending on which version of Excel you’re using, even if you format the errant cell as a date by selecting the cell, right-clicking and selecting Format Cells and choosing the Date option, that still won’t fix the problem.

How to Fix Dates That Won’t Sort Correctly in Excel

Fortunately, this problem is easy to fix.

1. Cut the column of dates by selecting the cells and pressing Ctrl+x, selecting Cut from the Home menu, or right-clicking on the cell(s) and choosing Cut.

1. Open Notepad or another plain text editor.
2. Paste the dates into the text editor.

1. Go back to Excel, select the column the dates used to be in, right-click and select Format Cells.
2. Choose Date and click OK.

1. Now go back to the text editor and select and copy the list of dates.

1. Go back to Excel and paste the dates into the column you formatted in step 5.
2. Now you should be able to sort. Select the columns with data, press the Sort & Filter button, and choose Sort Oldest to Newest. Viola! It works!

Other Sorting and Filtering Techniques in Excel

Now that you’ve learned how to sort by date in Excel, you might want to explore other ways to sort and filter your data. These articles will teach you basic one-column and multi-column data sorting, how to alphabetize in Excel, and how to filter data in Excel. 

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Daawashada iyo Gelida Taariikhda Dukumentiga Markii Ugu Dambeysay Lagu Bedelay Dukumeenti Kalmadeed

• Hagaha VBA Sare ee MS Excel

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel

• Sida Looga Saaro Safka Kooban Ee Excel

• U isticmaal Magacyada Range Dynamic ee Excel si aad u Dejiso Dabcida

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida loo isticmaalo Flash Fill ee Excel

• Sida loo qoro IF Formula/Bayaanka gudaha Excel

• Waa maxay VBA Array ee Excel iyo Sida loo Barnaamijyo Mid

• Sida Loo Sameeyo Shaxda Pivot Fudud ee Excel

• Sida Loo Wadaago Faylka Excel Si Fudud Layskula Shaqeeyo

• Sida Loo Raadiyo Excel