Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Sort by Date in Microsoft Excel

How to Sort by Date in Microsoft Excel

Asmi DhakalBy Asmi DhakalDecember 5, 2022
how-to-sort-by-date-in-excel

While making entries in your Excel spreadsheet, you may not have enough time to sort dates beforehand. Although it may sound like a tedious process of sorting dates out, it can be quite useful to keep track of deadlines, birthdays and anniversaries.

Excel, being one of the most used spreadsheets, offers features including a tool and formulas to make this task easier for you. This way, you do not have to go through the hassle of manually sorting each date out. If you’re interested in sorting dates in Excel according to weeks, months, days, and years, keep reading to get the dates sorted in no time!

Before You Start Sorting Dates

You must keep a few things in mind before sorting your data. For example, make sure that you are using a valid date format. You can change your date format from the Format Cells tab (Ctrl + 1 > Date).

The cell that contains your date is in the Date or General format. You can check the cell format from the Home tab. If the cell is not in the date format, you can select the fly-out menu in the Number section and choose Date or General. 

How to Sort Dates in Excel?

You can use the Sort & Filter tool to sort cells from ascending to descending order and vice-versa. However, you do not have the flexibility to sort dates by days, weeks, and months through this filter. You will have to use the library functions Excel offers to sort dates in this manner.

Use Sort and Filter Tool

The sort and filter tool is a quick way to sort dates from highest to lowest value. This tool sorts the dates according to the year. You will have to choose different options depending on whether you want to sort your dates according to ascending or descending order.

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

Use Excel Functions

If you wish to sort dates out by days, weeks, and months, you will first have to extract these data using the library functions. Then, you can use the Sort & Filter tool to sort your data from ascending to descending order or vice-versa. The following methods use dates in the mm/dd/yyyy format.

Sort Dates by Days

Sort dates by Days Execl

You might find sorting dates by days useful while working with deadlines. This way, you can view your employees’ approaching deadlines. Before entering the formula, ensure you have correctly entered your dates. 

On your worksheet, create a next column named “days”. On the first empty cell on the column, enter the formula in the following format:

=DAY(cell)

Sorting Dates by Weeks

sort dates by week

If you are dealing with longer deadlines, you can sort the dates by week. Create a new column named “weeks” and enter the formula in the following format on the first cell of the columns:

=WEEKDAY(cell)

Sorting Dates by Months

sort dates by months

You would want to sort your dates by month to keep track of birthdays, anniversaries, or annual events. Create a new column named “Months” on the worksheet with the dates you want to sort dates by month. On the first cell in the Months column, enter the formula in this format:

=MONTH(cell)

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

Macros are an amazing way to automate tasks in Excel. If you frequently need to sort dates out in Excel, you can record a Macro and run it the next time you want to get the job done. This will save you a lot of time compared to repeating these methods manually.

You can start recording a Macro from the Developer tab. After you hit record, you can carry on to continue the above-mentioned methods. Remember that all your actions are recorded, so only perform actions you wish to automate. Excel will record your keystrokes and save them as a Macro in the Visual Basics code.

how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
how long does a cmos battery last

How Long Does a CMOS Battery Last

January 25, 2023
thunderbolt vs usb c

Thunderbolt Vs USB C: What’s the Difference

January 25, 2023
how to find hidden folder in laptop

How to Find Hidden Folder in Laptop

January 24, 2023
You may also like
how-to-connect-headphones-to-tv

5 Ways to Connect Headphones to TV

January 29, 2023
connect-airpods-to-samsung-tv

How to Connect AirPods to Samsung TV? (Step-by-Step Guide)

January 29, 2023
AIO Pump Not Working

AIO Pump Not Working? Here’s How to Fix It

January 29, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.