• 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
33
301 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 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
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.00
  • Windows Server 2019 Datacenter Key Global Windows Server 2019 Datacenter Key Global
    Rated 4.75 out of 5
    $7.00
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.00
  • Microsoft Project Standard 2019 - 1 PC Microsoft Project Standard 2019 - 1 PC $12.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 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • Microsoft Visio Standard 2016 Key 1PC Microsoft Visio Standard 2016 Key 1PC $9.00
  • Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.69 out of 5
    $25.00
  • Windows 10 Enterprise Key Global Windows 10 Enterprise Key Global
    Rated 4.82 out of 5
    $9.00
  • Microsoft Office Home And Business 2019 CD Key for MAC Global Microsoft Office Home And Business 2019 CD Key for MAC Global
    Rated 4.95 out of 5
    $30.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.