• Microsoft Office
  • Microsoft Windows
  • Other Software
  • 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
  • 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
  • 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
  • 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.

5
58 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

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
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
    Rated 5.00 out of 5
    $11.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
    Rated 5.00 out of 5
    $45.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
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

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.