Cara Mengurutkan Tanggal di Excel

>Hello Sohib EditorOnline, if you are looking for a way to sort dates in Excel, you have come to the right place. Sorting dates in Excel can be a bit tricky, but with the right knowledge, it can be done easily. In this article, we will guide you step by step on how to sort dates in Excel.

Step 1: Understanding the Data

Before you start sorting dates in Excel, it is important to understand the data. Dates in Excel are stored as serial numbers, which means that Excel treats them as numbers. For example, January 1, 2020, is stored as 43831, where 1 represents January 1, 1900, and 43831 represents January 1, 2020.

You can also check if the cells with the dates are formatted as dates. To do this, select the cells and right-click on them. Select Format Cells and then select the Date option. If the cells are not formatted as dates, you will need to do so before sorting them.

Step 2: Sorting Dates in Ascending Order

To sort dates in ascending order, follow these steps:

1. Select the range of cells that contain the dates you want to sort.
2. Click on the Sort button in the Data tab.
3. In the Sort dialog box, select the column or row that contains the dates you want to sort.
4. Select the order in which you want to sort the dates. Select Oldest to Newest to sort dates in ascending order.
5. Click on OK.

After following these steps, Excel will sort the dates in ascending order. You can also use the shortcut key Alt + A + S + S to bring up the Sort dialog box.

Step 3: Sorting Dates in Descending Order

To sort dates in descending order, follow these steps:

1. Select the range of cells that contain the dates you want to sort.
2. Click on the Sort button in the Data tab.
3. In the Sort dialog box, select the column or row that contains the dates you want to sort.
4. Select the order in which you want to sort the dates. Select Newest to Oldest to sort dates in descending order.
5. Click on OK.

After following these steps, Excel will sort the dates in descending order. You can also use the shortcut key Alt + A + S + S to bring up the Sort dialog box.

Step 4: Sorting Dates by Month or Year

You can also sort dates by month or year. To do this, follow these steps:

1. Select the range of cells that contain the dates you want to sort.
2. Click on the Sort button in the Data tab.
3. In the Sort dialog box, select the column or row that contains the dates you want to sort.
4. Select Custom List from the Order dropdown list.
5. In the Custom Lists box, select either Month/Year or Year/Month from the list.
6. Click on OK.

After following these steps, Excel will sort the dates by month or year. You can also use the shortcut key Alt + A + S + S to bring up the Sort dialog box.

Step 5: Sorting Dates by Day of the Week

You can also sort dates by the day of the week. To do this, follow these steps:

1. Select the range of cells that contain the dates you want to sort.
2. Click on the Sort button in the Data tab.
3. In the Sort dialog box, select the column or row that contains the dates you want to sort.
4. Select Custom List from the Order dropdown list.
5. In the Custom Lists box, select either Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday from the list.
6. Click on OK.

After following these steps, Excel will sort the dates by the day of the week. You can also use the shortcut key Alt + A + S + S to bring up the Sort dialog box.

Step 6: Sorting Dates with Custom Formats

You can also sort dates with custom formats. To do this, follow these steps:

1. Select the range of cells that contain the dates you want to sort.
2. Click on the Sort button in the Data tab.
3. In the Sort dialog box, select the column or row that contains the dates you want to sort.
4. Select Custom Sort from the Order dropdown list.
5. In the Sort dialog box, select the column or row that contains the dates you want to sort.
6. Click on Add Level.
7. Select the column or row that contains the dates you want to sort.
8. Select the Custom List option from the Order dropdown list.
9. In the Custom Lists box, enter the custom format you want to sort the dates by.
10. Click on OK.

After following these steps, Excel will sort the dates with the custom format you entered. You can also use the shortcut key Alt + A + S + S to bring up the Sort dialog box.

FAQ

1. Can I sort dates in Excel without changing the format?

Yes, you can sort dates in Excel without changing the format. Excel will automatically recognize the dates and sort them accordingly.

2. Can I sort dates by day of the week?

Yes, you can sort dates by day of the week. Follow the steps in Step 5 to sort dates by day of the week.

3. Can I sort dates with custom formats?

Yes, you can sort dates with custom formats. Follow the steps in Step 6 to sort dates with custom formats.

4. Why are my dates not sorting correctly?

Your dates may not be sorting correctly because they are not formatted as dates or because they are not in a recognized date format. Check the formatting of the cells and make sure they are in a recognized date format.

Example Table

Date	Description	Amount
1/1/2020	Salary	$5,000
2/1/2020	Bonus	$1,000
3/1/2020	Rent	$1,500
4/1/2020	Electricity	$200

That’s it! You have now learned how to sort dates in Excel. Sorting dates in Excel is a useful skill that can help you organize your data and make it easier to read and analyze.

Cara Mengurutkan Tanggal di Excel