• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Sort By Date, Date and Time & Reverse Date Sort

0 Comments

When working with dates in Excel, sorting them is often necessary. Fortunately, Excel provides several options to sort dates based on different criteria. In this article, we will discuss how to sort by date, date and time, and reverse date sort in Excel.Sort By Date Date and Time Reverse Date Sort 1

Sort By Date

To sort by date in Excel, follow these steps:

  1. Select the column that contains the dates you want to sort. Sort By Date Date and Time Reverse Date Sort 2
  2. Go to the Data tab and click on the Sort button.Sort By Date Date and Time Reverse Date Sort 3
  3. In the Sort dialog box, select the column you want to sort by, and choose whether to sort in ascending or descending order.Sort By Date Date and Time Reverse Date Sort 4
  4. Make sure the “My data has headers” option is checked if your data has headers.
  5. Click OK to sort the column by dates.Sort By Date Date and Time Reverse Date Sort 6

The dates will be sorted in the oldest to newest order by default.

Sort By Date and Time

When you sort by date in Excel, the time values will also be considered. To sort by date and time, follow the same steps as sorting by date, but make sure to select the “Sort On” option as “Values” and the “Order” option as “Oldest to Newest”.Sort By Date Date and Time Reverse Date Sort 7

This will sort the dates in older to newer order, including the time values.Sort By Date Date and Time Reverse Date Sort 8

Reverse Sort By Date

To reverse the order of the sorted dates, simply change the “Order” option to “Newest to Oldest” in the Sort dialog box.

Sort By Years From Dates

If you want to sort by years from dates, you can use the YEAR function in a helper column. Follow these steps:

  1. Add a new column next to the column containing the dates.Sort By Date Date and Time Reverse Date Sort 9
  2. In the first cell of the new column, enter the formula “=YEAR(cell with the date)” and press Enter. This will extract the year from the date in the corresponding cell.
  3. Copy the formula down to all the cells in the column.Sort By Date Date and Time Reverse Date Sort 10
  4. Select both columns (the one with the dates and the one with the years) and go to the Sort dialog box.Sort By Date Date and Time Reverse Date Sort 11
  5. Select the years column as the primary sort column, and choose “Smallest to Largest” order.
  6. Click OK to sort the data.Sort By Date Date and Time Reverse Date Sort 12

This is how you can sort by dates using only the years.

In conclusion, sorting dates in Excel can be done easily using the SORT option. By following the steps outlined above, you can sort dates by date, date and time, and even by years. Additionally, you can also reverse the order of the sorted dates.

Rate this post
26
287 Views
How to Add a Watermark in ExcelPrevHow to Add a Watermark in ExcelApril 26, 2023
Counting Cells Below a Value in Excel using COUNTIFApril 26, 2023Counting Cells Below a Value in Excel using COUNTIFNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • Microsoft Visio Professional 2021 Key 1PC Microsoft Visio Professional 2021 Key 1PC $13.00
  • Windows 10 Education Key Global Windows 10 Education Key Global
    Rated 4.84 out of 5
    $9.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • Windows Server 2019 Datacenter Key Global Windows Server 2019 Datacenter Key Global
    Rated 4.75 out of 5
    $7.00
  • Windows 10 Pro N Key Global Windows 10 Pro N Key Global
    Rated 4.83 out of 5
    $10.00
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 4.72 out of 5
    $20.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.