How To Sort By Date In Microsoft Excel

While making entries in your Excel spreadsheet, you could not have sufficient time to kind dates beforehand. Although it could sound like a tedious strategy of sorting dates out, it may be fairly helpful to maintain observe of deadlines, birthdays and anniversaries.

Excel, being some of the used spreadsheets, provides options together with a software and formulation to make this job simpler for you. This approach, you should not have to undergo the trouble of manually sorting every date out. If you’re concerned with sorting dates in Excel in keeping with weeks, months, days, and years, keep studying to get the dates sorted very quickly!

Before You Start Sorting Dates

You should keep just a few issues in thoughts earlier than sorting your knowledge. For instance, just remember to are using a legitimate date format. You can change your date format from the Format Cells tab (Ctrl + 1 > Date).

The cell that accommodates your date is within the Date or General format. You can test the cell format from the Home tab. If the cell shouldn’t be within the date format, you may choose the fly-out menu within the Number part and select Date or General. 

How to Sort Dates in Excel?

You can use the Sort & Filter software to kind cells from ascending to descending order and vice-versa. However, you should not have the pliability to kind dates by days, weeks, and months by this filter. You should use the library features Excel provides to kind dates on this method.

Use Sort and Filter Tool

The kind and filter software is a fast approach to kind dates from highest to lowest worth. This software types the dates in keeping with the yr. You should select completely different choices relying on whether or not you wish to kind your dates in keeping with ascending or descending order.

1. On your workbook, choose the cell vary with the dates.
2. Head to the Data tab.
3. Select Sort from the Sort & Filter part.
4. Under Order, choose the fly-out menu.
5. To kind dates in ascending order, select Newest to Oldest.
6. For descending dates, choose Oldest to Newest.
7. Click OK.

Use Excel Functions

If you want to kind dates out by days, weeks, and months, you’ll first must extract these knowledge using the library features. Then, you should utilize the Sort & Filter software to kind your knowledge from ascending to descending order or vice-versa. The following strategies use dates within the mm/dd/yyyy format.

Sort Dates by Days

You may discover sorting dates by days helpful whereas working with deadlines. This approach, you may view your workers’ approaching deadlines. Before coming into the system, guarantee you’ve appropriately entered your dates. 

On your worksheet, create a next column named “days”. On the primary empty cell on the column, enter the system within the following format:

=DAY(cell)

Sorting Dates by Weeks

If you might be coping with longer deadlines, you may kind the dates by week. Create a brand new column named “weeks” and enter the system within the following format on the primary cell of the columns:

=WEEKDAY(cell)

Sorting Dates by Months

You would wish to kind your dates by month to maintain observe of birthdays, anniversaries, or annual occasions. Create a brand new column named “Months” on the worksheet with the dates you wish to kind dates by month. On the primary cell within the Months column, enter the system on this format:

=MONTH(cell)

How to Create a Macro to Automatically Sort Date in Excel?

Macros are a tremendous approach to automate duties in Excel. If you steadily must kind dates out in Excel, you may document a Macro and run it the subsequent time you wish to get the job performed. This will prevent lots of time in comparison with repeating these strategies manually.

You can begin recording a Macro from the Developer tab. After you hit document, you may stick with it to proceed the above-mentioned strategies. Remember that each one your actions are recorded, so solely carry out actions you want to automate. Excel will document your keystrokes and save them as a Macro within the Visual Basics code.